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
