Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 4 of 4 total |
Sales Quote Tutorial troubles |
Tue, Oct 13 2009 3:39 PM | Permanent Link |
Randy | I am using Delphi 2007 and working though the sales Quote tutorial and have run into a snag with the setuplaptops SQL loaded into a TEDBScripts
component. I get an error 700 on this......... IF ROWCOUNT(ConfigCursor) = 0 THEN EXECUTE IMMEDIATE 'CREATE STORE "LaptopSetup' + SalesPersonSuffix +'" AS LOCAL PATH ''c:\laptop' + SalesPersonSuffix + '\setup'''; END IF; I have narrowed it down to the SalesPersonSuffix variable. Without it - it seems to work. IF ROWCOUNT(ConfigCursor) = 0 THEN EXECUTE IMMEDIATE 'CREATE STORE "LaptopSetup" AS LOCAL PATH ''c:\laptop'''; END IF; I can't seem to pin down a proper syntax to combine the variable with a constant string. |
Tue, Oct 13 2009 5:00 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Randy,
<< I get an error 700 on this......... >> What is the actual error message ? The examples should work fine provided that you're executing them properly with valid parameter values. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Oct 13 2009 5:55 PM | Permanent Link |
Randy | Thanks Tim
Looks like maybe it was the need for setting a value for the parameter. It was not a clear message though. I have attached a screen shot. Attachments: error.JPG |
Thu, Oct 15 2009 2:02 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Randy,
<< Looks like maybe it was the need for setting a value for the parameter. It was not a clear message though. I have attached a screen shot. >> Yes, I suspected that this was the case. The error message isn't helpful, but they usually aren't when you have an SQL statement that isn't built properly. What the script should probably do is check to see if the parameter is NULL, and then issue an error with a RAISE statement. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |