>>Look at it again... the UPDATE will NOT work unless the LAstNumber is still what it was when the selet was done. Look at the WHERE of the update.
>Bob,
>sorry about that, you are absolutely right. What I was thinking?
>OTOH, I think SQLExec will return 1 even when UPDATE will not update anything and lSuccess will be always TRUE.
>lSuccess = ( SQLExec(nConn, cSQL) = 1 )
>
>Oleg

DOH! You are right of course, you have to select @@Rowcount!!!

Sorry Pasqule!!!

BOb