Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
As we all know if we are connecting through SalesForce DB then we can not use "Select *" statement in the script.
I did some search and found by using SalesForceDLL.dll we can use "Select *" in the our application.
I have that .ddl file but dont know how to use it.
Can anyone please let me step by step how to use this .dll file to use "Select *" in my application.
Thanks.
try tis way,
select SalesForceDLL.dll from database dropdown from DATA tab and click connect--key in ur username&password--test connection,then so..
CUSTOM CONNECT TO XXXXXXXX-----will create.
KeyTable:
SystemModstamp as Key1,
CreatedById,
CreatedDate,
Id,
IsDeleted,
LastActivityDate,
LastModifiedById,
LastModifiedDate,
LastReferencedDate,
LastViewedDate,
Name,
SystemModstamp;
SQL SELECT
CreatedById,
CreatedDate,
Id,
IsDeleted,
LastActivityDate,
LastModifiedById,
LastModifiedDate,
LastReferencedDate,
LastViewedDate,
Name,
SystemModstamp
FROM XXXXXXX;
it will work
Hi Shiva,
I am able to connect with SalesForce. but the problem is, if I use "select *" its throwing error message.
As per your script following "Load * " is not working.
KeyTable:
Load *;
SQL SELECT
CreatedById,
CreatedDate,
Id,
IsDeleted,
LastActivityDate,
LastModifiedById,
LastModifiedDate,
LastReferencedDate,
LastViewedDate,
Name,
SystemModstamp
FROM XXXXXXX;
i think latest connector will support, and few restrictions aswell.
PFA,
"The “SELECT *” statement can be added manually in the SOQL Query text box to select all fields in the table. The SOQL query language does not support the “SELECT *” statement, but the Salesforce Connector has been enhanced to recognize that syntax. Only asterisks (*) and simple field names can be used in the SELECT statement. Qualified field names, such as “Contact.FirstName,” are not permitted. The “SELECT *” statement can only be used when Bulk is selected."
for ur reference,i'm successfully load the data with the above syntax.