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!

External Development Forums - SalesLogix OLEDB Provider
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.

Forums RSS Feed

Back to Forum List | Back to SalesLogix OLEDB Provider | New Thread

View: Search:

Author

Thread: Seeing an SLX view through the provider

David
Posts: 29

Seeing an SLX view through the provider Your last visit to this thread was on 1/1/1970 12:00:00 AM

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.

[Reply][Quote]

Mike Spragg
Posts: 1226

Re: Seeing an SLX view through the provider Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 Apr 08 5:42 AM

Those are SLX views and, as such, maybe "special" !! Did you try a real view (one you created) ?

[Reply][Quote]

David
Posts: 29

Re: Seeing an SLX view through the provider Your last visit to this thread was on 1/1/1970 12:00:00 AM

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

[Reply][Quote]

Mike Spragg
Posts: 1226

Re: Seeing an SLX view through the provider Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 Apr 08 6:13 AM

Can you post the code you are using to attempt this - maybe something in there will give us a clue - as it does work ordinarily.

[Reply][Quote]

Page 1 of 1

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!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/23/2024 1:02:29 AM