>I am inserting a value into a table. When I insert into a table a program runs (called nextid.prg written by Eldor Gemst used in default value of table structure) that put a unique "ID" into my table. My question is, after I do an insert into a table, is there way to retrieve the values of this record I just inserted. I am trying to retrieve the "ID" value that was generated by nextid.prg of the record I just inserted? I hope this make sense.
>
>thanks in advance
>Nick Patel
Nick,
That value is field's value (that uses nextid() as default). Just query it. ie: If myPKId field has default NextId() after inserting, mytable.myPKId has that value.
Cetin