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: Scalar function issue

Marc Murphy
Posts: 23

Scalar function issue Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 19 Dec 07 5:35 PM

Hey Guys,

So we could never get the sales dashboard to work with out internal SLX installation. We've done a pilot upgrade to SLX v7.2 on SQL Server 2005 and again the dashboard fails to work. It fails to parse SQL strings being passed to the database. While investigating this using the SLX & SQL Server profilers I believe that my scalar functions are failing to be transformed into their SQL Server equivalent and as such fail to parse.

From my understanding the scalar functions (i.e. SLXDateDiff) used within SLX get transformed by the provider into the correct function depending on what Database you use so for SQL Server SLXDateDiff becomes DateDiff and Becomes - ( Minus Sign ) in Oracle (im guessing here, as i dont ever use Oracle).

Using the Profiler I see that the original SLXDateDiff is passed rather than DateDiff

I've used both the available OLE DB providers when setting up my connection but to no avail
- Microsoft OLD DB Provider SQL Server
- SQL Native Client

Im seriously stumped here, i've never come across an issue like this before does anyone have any idea how i get the provider to correctly identify what database its connected to?

This could be a SQL Server issue as well but again im stumped on how i'd resolve it on the SQL server side

Any advice or nudge in the right direction would be really appreciated

[Reply][Quote]

Marc Murphy
Posts: 23

Re: Scalar function issue Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Dec 07 10:30 AM

*** Update ***

From talking with SLX support they reckon ( more like a guess to be honest ) that some part of the v7 upgrade failed to release correctly. as such they have recommended that I go through the entire v7 release and unrelease and release each of the v7 plugins.

I'll post an update afterwards.

[Reply][Quote]

Jason Huber
Posts: 77

Re: Scalar function issue Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Dec 07 7:59 AM

It just occurred to me and it is probably useless and too late as well, but -
Did you try to just reinstall the provider first?

[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): 8/18/2025 8:03:22 AM