Re: Rowid after an insert???

Assuming that your application knows the primary or alternate key value of the row it just inserted, you could always retrieve the rowid with a suitable SELECT.

A slight overhead but probably not significant given the frequency with which an interactive application would do it (as opposed to a batch type app which was inserting large numbers of rows).

David (djh_at_cix.compulink.co.uk) Received on Wed Sep 11 1996 - 00:00:00 CEST