Results 1 to 7 of 7

Thread: [RESOLVED] Confused - date update causing - Row cannot be located for updating

Threaded View

  1. Jun 7th, 2006, 03:00 PM #1
    anneq
    anneq is offline

    Thread Starter
    Junior Member
    Join Date
    Sep 2005
    Posts
    23

    Resolved [RESOLVED] Confused - date update causing - Row cannot be located for updating

    Hi,

    I'm Using ADODB with mySQL. When updating if I exclude two dates on the update then all is ok, But if I changed them with the data from the screen and the recordset.update. I get the error that data has changed since you found it. I was wondering if anybody could help me out on a direction to look in, as I can't figure out why its the dates that are causing the issue. I am opening my recordset as follows

    pRs.Open SQL1, gCnn, adOpenStatic, adLockOptimistic, adCmdText

    thanks

    Anne
    Last edited by anneq; Jun 7th, 2006 at 03:30 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width