First I tryed to delete using a IB_Query without any special
DeleteSQL string. I get an error msg that I could not delete the
used or active record. I could not undestand the logic, since I was
using a query to find if value1 was present in table2, if it was
present, I would like to delete the record in table1.
The table1 structure is:
key
.....
field1
field2
in which we can have several diferent records with the same values in
fields 1 and 2.
So I set the deleteSQL string to: 'delete from table1 where field1
= 'Y' and field2 = :field2'
using the instructions: 'Myquery.delete' I get an error that I was
trying to delete multiple records. Ok, I realy want to delete
multiple records.
If someone could help showing where are my error, I would thanks very
much.
Edison