Resolved via email.

   As probably suspected all along it was me.

   I didn't check the LoadFromFile action.  It was overwriting my pre added SQL
commands.

My thanks to Tim once again.

Ian




--

Ian Branch wrote:

> Hi Guys,
>
>    D7Pro, Latest DBISAM.
>
> When I run the following code/query in a DBISAMQuery....where
> "lbTarget.Items[vTCnt]" contains 'accounts.sql', sans the quotes.
>
>
>         SQL.Clear;
>         Sql.Add('empty table ' + LeftStr(lbTarget.Items[vTCnt],
> Length(lbTarget.Items[vTCnt]) - 4) + ';');
>         Sql.Add('Start Transaction;');
>         Sql.LoadFromFile(eTargetDir.Text + '\' +
> lbTarget.Items[vTCnt]);         Sql.Add('Commit;');
>         ExecSQL;   
>
> I get a duplicate index error which to me indicates the empty table
> command is not happening.
>
> Any thoughts as to what I have missed?
>
> Regards & TIA,
>
> Ian

Ian

Won't the LoadFromFile clear the previous contents of SQL, so the EMPTY
TABLE and START TRANSACTION are both lost?

Cheers

Jeff

--
Jeff Cook
Aspect Systems Ltd
www.aspect.co.nz
+
Joan and Jeff Cook
The Cooks Oasis
www.cookislandsoasis.com

And how weird that XanaNews suddenly popped up this old thread as a new
one!

I will now go away.

--
Jeff Cook
Aspect Systems Ltd
www.aspect.co.nz
+
Joan and Jeff Cook
The Cooks Oasis
www.cookislandsoasis.com