>Hi,
>
>I want to create an oracle cursor that has the record number as a column.
>
>Is there a function like vfp recno()?
>
>Paul de Niverville
Since you found the answer to your own question, I will just make a comment. I highly recommend against using this as PK or FK or anything meaningful. Oracle calls this a pseudo-column which means a false column. There are no guarantees that this row number will always be the same throughout the lifetime of the databse. For example, if you backup the database using the Oracle EXP [export] utility, then use IMP [import] to restore the DB, these IDs could change.
Mark McCasland
Midlothian, TX USA