Delphi Client Gets database update information (number of update bars)

1.SQL statements

if  not  Exists  (select  1  from  TB where xxx='xxx')  //  does not exist, the Insert data    beginINSERT INTO  TB (XXX) VALUES (' XXX ')  //     End1 as RC             //Key is this statement, read the updated information

2. The client obtains the update situation, I use clientdataset here.

 with  Do begin   CommandText:=sql; // This SQL is the SQL statement above  Open;                    // Note that you must use open here without exec   showmessage (IntToStr (cds.fieldbyname ('RC'). Asinteger)); End;

Delphi Client Gets database update information (number of update bars)