Select * in Salesforce

[soha1902]

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.

[buzzy996]

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

[soha1902]

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;

[buzzy996]

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."

[buzzy996]

for ur reference,i'm successfully load the data with the above syntax.