4 Replies Latest reply: May 18, 2015 6:03 AM by Shiva Reddy RSS

    Select * in Salesforce

    soha singh


      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.

        • Re: Select * in Salesforce
          Shiva Reddy

          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

            • Re: Select * in Salesforce
              soha singh

              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;