8/24/2025 9:38:17 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
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!
Forum to discuss using the SalesLogix OLE DB Provider from external applications (including usage of built-in provider procedures). View the code of conduct for posting guidelines.
|
|
|
|
Seeing an SLX view through the provider
Posted: 11 Apr 08 9:41 AM
|
Hi
When connecting to SLX through the provider, if we try to query a view (for example Account_), we get the following error:
Select accountid from sysdba.ACCOUNT_
ErrNo : 0
Native ErrNo : 0
Source : SalesLogix OLE DB Provider
Description : Incorrect syntax near the keyword 'from'.
I have also tried:
Select accountid from sysdba.ACCOUNT_
Select accountid from sysdba.[ACCOUNT_]
Select accountid from ACCOUNT_
Selecting from the ACCOUNT table works fine.
Select accountid from ACCOUNT
Presumably I am doing something stupid. Any suggestions welcome. |
|
|
| |
|
Re: Seeing an SLX view through the provider
Posted: 12 Apr 08 6:10 AM
|
Hi Mike
Yes I did - started with that, and when that didn't worked tried the SLX view because I assumed I had done something wrong. 
Any suggestions?
Regards
David |
|
|
| |
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|