I've searched the forum, but I couldn't find an answer in the existing posts...

I am executing an SQL query which I know will return only one record.  I
will then insert a record, then delete the record I returned from the DB.  Is
using the DataTable the most effiecient way to do this?

PJSimon

I advise you to use transactions in your code! It's the eficient way to do
this!
Read the record to the datatable, and then begin the transaction! if the
delete goes wrong you could roll back the insert.

DanyR.


Show quoteHide quote

dim x as something
Extracting XML in VB
Error calling unmanaged DLL
Problems with settings.
Input data to website
Nullable types and datareader...
Creating databases from VB2005 Express or VB2005
About Splash Screen form setting
Measre Distance using the PostCode
error handle