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 & “‘”