How do I populate a SalesLogix Datagrid using script?

Question:Can I  populate a datagrid with information from a different database than our SalesLogix using script?

Answer:The SLX Provider can access tables and (critically in this case) views which are in the current SLX database and which are owned by the sysdba schema (so sysdba.viewname, not dbo.viewname).

Create your view and make it accessible. Then you can use the following script.

strSQL = “Select A.ID FROM myView A Where A.SalesLogix = ‘” & application.BasicFunctions.CurrentAccountID & “‘”

 

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!