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: FYI: Rear end spanked comparing Decimal to Double!

RJ Samp
Posts: 973

FYI: Rear end spanked comparing Decimal to Double! Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Jan 09 8:37 AM

OUCH! A Routine just blew up....comparing Opportunity.SalesPotential to cDBL(EditBox.Text value).....
turns out that those SQL 17,4 fields are VarType 14.....not 5.

And I don't know of a cDEC or cNUMER conversion.....

Solution:

TempAmount = cDBL(QRS.Fields(0).VALUE) '''''''VarType 14 from RecordSet
TempAmount2 = cDBL("0" & numReNewBus.TEXT) '''' VarType 5 from Text Edit Box databound to VarType 14 17,4 database field.
''' msgBOX TempAmount & " " & VarType(TempAmount) & " " & TempAmount2 & " " & VarType(TempAmount2)
IF TempAmount <> tempAmount2 THEN

Now back to my normal program of regularly scheduled disciplinary actions.

[Reply][Quote]

Jeff Weight
Posts: 219

Re: FYI: Rear end spanked comparing Decimal to Double! Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Jan 09 8:47 AM

So, essentially, convert everything using cDbl and you'll be fine? Sounds good to me - I just went through this exercise as well, since I am in the middle of upgrading a system from 6.2.6 to 7.5.

Thanks for helpful hint on the VarType function - I never knew that existed! I'm sure I'll be able to put that to use soon...

[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/27/2025 10:23:44 PM