Re: Can I add the SQL of a DataAdapter into a Transaction

Hi Bob,

Oh my apologies. I notice that now... Only ADO. Yes. I need to post
correctly - bad newsgroup etiquette.

The records are coming from a SQL Server DB that is being updated all the
time so I will be polling for new records to pick up and process. These
records then need to be massaged and then call some COBOL programs via MQ on
DB2, hence why I need to update the "new" status of records in the table to
"processing" while this other task occurs.

Cheers



--
Kind Regards
Amelia


"Bob Barrows [MVP]" wrote:

Amelia wrote:
I need to retrieve a set of data to work on from a DB table. BEfore I
work on the data I need to update these records as "Being Processed"
and then go back to process the required records.

What I was going to do was to retrieve records into a DataSet, update
status in the DB table and then loop through DataSet to update
records - BUT jsut to be sure, I still want to wrap up retrieval and
update of records in a transaction. Is this possible?

There was no way for you to know it (except maybe by browsing through some
of the previous questions in this newsgroup before posting yours - always a
recommended practice) , but this is a classic ADO newsgroup. ADO.Net bears
very little resemblance to classic ADO so, while you may be lucky enough to
find a dotnet-knowledgeable person here who can answer your question, you
can eliminate the luck factor by posting your question to a group where
those dotnet-knowledgeable people hang out. I suggest
microsoft.public.dotnet.framework.adonet.

However, you should probably run this task by someone to verify that you
actually need to do this process in a loop. I have rarely seen a looped
update that could not be rewritten as a more robust and efficient set
operation. What DB are you using?

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"



.

Relevant Pages