Home All Groups Group Topic Archive Search About

Update in DB but not in SELECT

Author
28 Oct 2006 6:59 PM
Stephen Plotnick
I do an UPDATE with SQL using OLEDB and when I try to go back to the Select
statement it does not find the updated field. If I try SELECT a second time
they are there.

I did look at the actual Access DB and the field is updated properly after
the UPDATE statement.

Steve

Author
28 Oct 2006 8:31 PM
Josip Medved
> I do an UPDATE with SQL using OLEDB and when I try to go back to the Select
> statement it does not find the updated field. If I try SELECT a second time
> they are there.

These things usually happen if one connection is used for writing and
yet another
one for reading. Use same connection for both UPDATE and SELECT.

--
Pozdrav,
  Josip Medved
  http://www.jmedved.com