Hi Fabio,

Yes, your code would work (I think) since you do a tableupdate and thus forces VFP to add the row to the underlying table and that triggers the AutoInc.

My issue was, how can I get the AutoInc value via the view without having to commit the row?

As Tore pointed out, it looks like I may have to wait for VFP9.


Regards,

Mike


>
>I have a view of a table that includes an autoinc field from the underlying table. When I insert a new record into the view, the autoinc field does not autoinc like it does when I insert directly to the table itself.
>
>Is there some way that I can have the view get the autoinc value that the table would use without actually adding the record to the table? After all, that would defeat the purpose of my buffered view wouldn't it?
>
>
>I try it:
>- define a local view for a table with autoinc field
>- set autoinc field not updatable
>- add a row ( or more with tablebuffering )
>- tableupdate the view
>- REQUERY() return me new autoinc values
>
>Fabio