>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