The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Populate Datagrid with data from a different database
Posted: 18 Feb 09 8:33 PM
|
Hi all.
I want to populate a datagrid with information from a different database from our SalesLogix. I populate the datagrid using script, here's an example:
strSQL = "Select A.ID FROM [DifferentDatabase].dbo.myTable A Where A.SalesLogix = '" & application.BasicFunctions.CurrentAccountID & "'"
When I run this in the client, I get the following error: "Invalid Table Name"
How can I access a table in a different database from our SalesLogix data?
Thank you in advance. |
|
|
|
Re: Populate Datagrid with data from a different database
Posted: 19 Feb 09 3:07 AM
|
Presumably you do not have remotes, or this will not work at all ...
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).
So your first step is to create the view in the SLX database, using standard SSMS techniques - but remember the sysdba bit.
Then you need to register the view to SLX, using the database manager. If you need more details, just ask.
Then you should be good to go with
strSQL = "Select A.ID FROM myView A Where A.SalesLogix = etc etc "
Phil |
|
|
| |
| |
| |
|