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: SQL NVarChar translation in SLX

Ezi Porbeni
Posts: 11

SQL NVarChar translation in SLX Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 May 08 10:34 AM

In the SLX database I have table views pointing to a SQL database. Several of the fields in the SQL database are defined as nvarchar, however SLX either treats these as blobs (in the query builder interface) or undefined (the SLX DB manager shows them with N\A data type). How can I get SLX to recognize\define these are string fields? Why does SLX not support commonly used SQL data types if we're using SQL databases?

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: SQL NVarChar translation in SLX Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 May 08 11:06 AM

Quote:

Originally posted by Ezi Porbeni

Why does SLX not support commonly used SQL data types if we're using SQL databases?

1) Because of old Delphi code, originally written for Interbase & BDE
2) Because of it's need to support multiple database platforms (supports Oracle as well)

I think it is mostly #1

-Ryan

[Reply][Quote]

Ezi Porbeni
Posts: 11

Re: SQL NVarChar translation in SLX Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 May 08 11:19 AM

Does this mean I can't get SLX to recognize\define nvarchar SQL fields as SLX string fields?

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: SQL NVarChar translation in SLX Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 May 08 11:29 AM

Quote:

Originally posted by Ezi Porbeni

Does this mean I can't get SLX to recognize\define nvarchar SQL fields as SLX string fields?

If it's not it's not. I don't think there is going to be any way to change this (but I've never looked into it either).

[Reply][Quote]

Ezi Porbeni
Posts: 11

Re: SQL NVarChar translation in SLX Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 May 08 11:50 AM

Ok. How about support for foreign language characters in SLX. My understanding is that SLX supports foreign characters by allowing for 2-byte characters in our slx string fields. However in version 7.2.2 I can paste foreign language characters and some (like Korean), get displayed as ??? signs. What am I missing?

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: SQL NVarChar translation in SLX Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 May 08 8:10 PM

Take a look at this article, it might help: http://www.slxdeveloper.com/page.aspx?action=viewarticle&articleid=104

-Ryan

[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:12:26 AM