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!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: common sql functions for Oracle and MSSQL

Satheesh Allam
Posts: 5

common sql functions for Oracle and MSSQL Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 14 May 07 1:41 PM

Hi

We are using Oracle as backend database for SLX. However all remote users, of course, use MSDE (MSSQL).

We have cusomized the SLX by building our own forms and script to add and products with in an opportunity. In this I want to use the oracle funtions like NVL, SYSDATE, ROWNUM in the select statements. This works fine in the Network client as it is pointing to Oracle. When the script is moved to remote clients, it fails, becasue these are not valid in MSDE (MSSQL).

Is there any alternative functions which will work both in Oracle and MSSQL? or Is there a way I can figure out where the script is running (network client or remote client) so that I can substitute the code accordingly?

Looking for the help as soon as possible.

Thanks,
Satheesh

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: common sql functions for Oracle and MSSQL Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 14 May 07 1:52 PM

Your best bet is to avoid SQL & Oracle specific functions, however, you could determine at runtime if you are on a remote or not to adjust the code accordingly. See http://www.slxdeveloper.com/forum.aspx?forumid=2000&postid=6012#6012

Make sense?

[Reply][Quote]

Satheesh Allam
Posts: 5

Re: common sql functions for Oracle and MSSQL Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 14 May 07 2:38 PM

Thanks Ryan for you timely help

[Reply][Quote]

Todd Hardin
Posts: 43

Re: common sql functions for Oracle and MSSQL Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 May 07 4:00 PM

SLX has support for custom scalar functions via COM extensions loaded by the SLX OleDB provider. I believe this is now officially supported in v7.0.x (someone correct me if this is still "technology preview" in v7.0.x, but I ma pretty sure it is officially supported now).

There is very little documentation on this exciting feature at present, however we are expecting some documentation from the SLX Team in the coming weeks.

Todd Hardin

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: common sql functions for Oracle and MSSQL Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 May 07 5:41 PM

Yep.. there's already some "built-ins" that Slx Provides and uses:
EX:
SLXDATEPART
SLXDATENAME
SLXDATEDIFF
SLXDATEADD
SLXGETDATE (my favorite

SLXSTR
SLXCAT

--
rjl

[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 © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 6/18/2025 12:59:22 PM