Hi all,

If I have the following code:

with query1 do                            { dummy code }
 begin                                    { more than likey to have syntax }
  SQL.clear;                              { errors :) }
  SQL.add('Insert into TableXX values('A','B') ');
  SQL.add('where FieldA = 'XXXX');
  ExecSQL;
 end;

How do I find out how many rows where affected ? ie If 0 rows were affected
I should be doing my error routines.

Thanks

Jonathan

--
---
+-------------------------------------+-------------------------------------+
|Jonathan & Christopher Ackerman      |And, for an instant, she stared      |
|{*filter*}ed Web Surfers and Game Players|directly into those soft blue eyes   |

|Web   - http://www.*-*-*.com/ ~jack |mammalian certainty, that the        |
|                                     |exceedingly rich were no longer even |
|                                     |remotely human.  - Count Zero,       |
|                                     |William Gibson                       |
+-------------------------------------+-------------------------------------+