Thanks, I was hoping I wasn't going to come to that but I had on of those
feelings :-)
-----Original Message-----
From: BJ <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Date: Wednesday, 2 December 1998 15:12
Subject: RE: [DUG]: Help with SQL and ODBC
>Happy Day.
>
>Try to queries:
>
>Qry1:
>SELECT Palletexport.Barcode FROM "PalletExport.DBF" Palletexport
> WHERE Palletexport.ACK_MESS = '00-OK'
>
>Qry2:
>DELETE FROM ":OneWorld:testdta.F59JL02" F59JL02
>WHERE F59JL02.UDBAR = :value
>
>Open Qry1 and traverse through all records. On each record, pass the
>barcode field as a parameter to Qry2 and execute Qry2.
>
>while not Qry1.EOF do
>begin
> Qry2.ParamByName('value').AsString =
>Qry1.FieldByName('BarCode').AsString;
> Qry2.ExecSQL;
> Qry1.Next;
>end;
>
>You might not want to go through this hassle, but I know it will work
>because you know that the individual SQL statements work. I haven't dealt
>with single queries that access multiple databases before.
>
>Cheers.
> BJ...
>
>----------
>From: Maurice Butler[SMTP:[EMAIL PROTECTED]]
>Reply To: [EMAIL PROTECTED]
>Sent: Wednesday, 02 December, 1998 14:58
>To: Multiple recipients of list delphi
>Subject: [DUG]: Help with SQL and ODBC
>
>Hi,
>I have a heterogenous SQL Queries that deletes data off the server if it
>exists in a local table. It always brings up an AVat xx in IDOBC32.dll at
>write address XX after it has deleted the first record of a set.
>
>the query is
>DELETE FROM ":OneWorld:testdta.F59JL02" F59JL02
>WHERE F59JL02.UDBAR IN (SELECT Palletexport.Barcode FROM "PalletExport.DBF"
>Palletexport
> WHERE Palletexport.ACK_MESS = '00-OK')
>
> I have tested the delete as
>DELETE FROM ":OneWorld:testdta.F59JL02" F59JL02
>WHERE F59JL02.UDBAR = value
> and it works fine
>
>I have tested the select as
>SELECT Palletexport.Barcode FROM "PalletExport.DBF" Palletexport
> WHERE Palletexport.ACK_MESS = '00-OK'
>and it works fine.
>
>":OneWorld:testdta.F59JL02" is on the MS SQL server
>and "PalletExport.DBF" is the local table.
>------------------------------------------------------------------------
>----
>----
>Maurice Butler Like Magic Ltd (025) 273 9248
>
>
>---------------------------------------------------------------------------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
>---------------------------------------------------------------------------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
