Hi Guys,

   Is the following SQL valid when loadedint TEDBQuery.SQL and followed by an
ExecSQL?

----
BEGIN;
INSERT INTO accounts
 (ACCTNUMB, ACCTDESC, JOB_CODE, TAXABLE, COSTASSELL)
VALUES
 ("10100", "MOTOROLA CELLULAR WARRANTY", "WTY", 1, 1);

INSERT INTO accounts
 (ACCTNUMB, ACCTDESC, JOB_CODE, TAXABLE, COSTASSELL)
VALUES
 ("10200", "TWO WAY WARRANTY", "WTY", 1, 1);

INSERT INTO accounts
 (ACCTNUMB, ACCTDESC, JOB_CODE, TAXABLE, COSTASSELL)
VALUES
 ("10101", "CELLULAR TIME & MATERIAL", "T&M", 1, 0);

INSERT INTO accounts
 (ACCTNUMB, ACCTDESC, JOB_CODE, TAXABLE, COSTASSELL)
VALUES
 ("10110", "CELLULAR SERVICE WARRANTY", "SVC", 0, 1);
COMMIT;
----

Regards,

Ian

Ian


Nope - its a script which is unsupported just now. You'll need to process each statement individually.

Roy Lambert

Roy Lambert wrote:

> Ian
>
>
> Nope - its a script which is unsupported just now. You'll need to process
> each statement individually.
>


Hi Roy,

   Bummer, I was afraid of that.  So much for that plan.  For now.

Regards,

Ian

--

Ian,
Can't you do the following?

INSERT INTO accounts
  (ACCTNUMB, ACCTDESC, JOB_CODE, TAXABLE, COSTASSELL)
VALUES
  ("10100", "MOTOROLA CELLULAR WARRANTY", "WTY", 1, 1),
  ("10200", "TWO WAY WARRANTY", "WTY", 1, 1),
  ("10101", "CELLULAR TIME & MATERIAL", "T&M", 1, 0),
  ("10110", "CELLULAR SERVICE WARRANTY", "SVC", 0, 1);

This works in MySQL.

Dave

Dave Harrison wrote:

> Ian,
> Can't you do the following?
>
> INSERT INTO accounts
>   (ACCTNUMB, ACCTDESC, JOB_CODE, TAXABLE, COSTASSELL)
> VALUES
>   ("10100", "MOTOROLA CELLULAR WARRANTY", "WTY", 1, 1),
>   ("10200", "TWO WAY WARRANTY", "WTY", 1, 1),
>   ("10101", "CELLULAR TIME & MATERIAL", "T&M", 1, 0),
>   ("10110", "CELLULAR SERVICE WARRANTY", "SVC", 0, 1);
>
> This works in MySQL.
>
> Dave

Hi Dave,

   Yup, works in MySQL but not in EDB, yet.

Regards,

Ian

--

Ian Branch wrote:

>    Is the following SQL valid when loadedint TEDBQuery.SQL and followed
> by an ExecSQL?


a stored procedure would execute the statement...
something like this:

PREPARE stmt FROM 'INSERT INTO accounts (?,?,?,?,?)';
START TRANSACTION;
EXECUTE stmt USING '10100', 'MOTOROLA CELLULAR WARRANTY', 'WTY', 1, 1;
EXECUTE stmt USING '10200', 'TWO WAY WARRANTY', 'WTY', 1, 1;
EXECUTE stmt USING '10101', 'CELLULAR TIME & MATERIAL', 'T&M', 1, 0;
EXECUTE stmt USING '10110', 'CELLULAR SERVICE WARRANTY', 'SVC', 0, 1;
COMMIT;
UNPREPARE stmt;

but I think that's not what you've been looking for..

regards
ralf

Ian,

<< Is the following SQL valid when loadedint TEDBQuery.SQL and followed by
an ExecSQL? >>

As already indicated, support for scripts if forthcoming, but not available
yet.

--
Tim Young
Elevate Software
www.elevatesoft.com