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.

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

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.

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