Re: SELECT FOR UPDATE in ESQL/C?

In article <Cs1Yw0ElJXBI083yn@kcbbs.gen.nz> kerry@kcbbs.gen.nz "Kerry Sainsbury" writes: > I was just wondering how "SELECT ... FOR UPDATE" in conjunction with > "UPDATE ... WHERE CURRENT OF" works in languages using embedded SQL. > > How does the "WHERE CURRENT OF" bit get the cursor information from? > > (I want to use this via ODBC, but can't figure out how to do it yet) Kerry, At a stab, I'd say that it probably gets it out of the sqlca record somewhere. No manuals to hand, but I seem to recall that sqlca.sqlerrd[6] is the rowid of the last record touched. It's something like that, anyway. HTH, Spokey the Wheeler------------------------------------------------------------- "Billy Boy" - das aufregend andere kondom! Carter - the Unstoppable Sex Machine / Wheeler - the Unstoppable Mail Machine!