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: Error on updating an Opportunity Detail

Matt Tollestrup
Posts: 7

Error on updating an Opportunity Detail Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 24 Nov 08 11:59 AM

I am getting a script error:

"An error occurred executing active form script (System:Opportunity Detail).
Error in include script (SYSTEM:SLX DATABASE SUPPORT): Error calling method pklStatusPopupReturn

Error converting data type varchat to numeric.

at line 225, char 10."

Looking in the code, line 225 is

" objTabView.txtPriceTotal.Text = FormatPrice(GetExtendedPriceTotal(objTabView.grdProducts.Recordset), GetMCValue(MC_On))"

This code updates an opportunity, and from the error I would guess that the value being returned by GetExtendedPriceTotal(objTabView.grdProducts.Recordset) is a varchar; however, I am not sure how to proceed with it. I am just getting into SLX, and inheriting most of the scripting from another developer. Can anyone point me in the right direction on how to troubleshoot this issue and eliminate the error? Is there a function that I can put around the returned value to ensure it returns numeric and converts properly?

Thanks!

[Reply][Quote]

Kris Halsrud
Posts: 88

Re: Error on updating an Opportunity Detail Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Nov 08 9:23 AM

You can attach a debugger to your code and then see what is being returned in the script. If you add "stop" right above this line. When you then execute the script in SLX you will enter into debugging. You must first turn debugging on. This is done in the SLX client under Tools...Options on the Other tab, in the debug drop down choose on Error.

If you dont have Visual Studio or similar debugging tools, you can find a link for download here:
http://www.slxdeveloper.com/page.aspx?id=28

[Reply][Quote]

Kris Halsrud
Posts: 88

Re: Error on updating an Opportunity Detail Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Nov 08 9:26 AM

Another quick and dirty thing you could try is to add message boxes in to see what is being returned:

msgbox FormatPrice(GetExtendedPriceTotal(objTabView.grdProducts.Recordset), GetMCValue(MC_On))"
msgbox GetMCValue(MC_On)

If you need the cdbl or cint functions can be used to convert strings to numeric. See here for info:
http://www.slxdeveloper.com/page.aspx?action=viewarticle&articleid=30

[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 2:29:11 PM