Here we go
Why AutoInc fields may be not a good idea with CA Thread #
1235061 You need to get AutoInc field value after your tableupdate (see methods discussed in these threads) and then you can do CursorRefresh.
>I'm totally unexperienced with remote data access, and I'm trying to access my DBC using CursorAdapters with OLEDB.
>
>I managed to create my CA vcx, using Mark McCasland CABuilder for VFP9.
>
>In the DBC I have some AutoInc fields as PK, and I'm being able to update and delete data normally.
>
>But I noticed that when I insert data, the PK field is not updated, even after I send a TABLEUPDATE() command.
>
>I can only see the AutoInc values after I close my form that uses the CA.
>
>Is this the normal behavior or is there any way to allow me to see the AutoInc field updated ?
>
>Thanks in advance
>
>Cesar
If it's not broken, fix it until it is.
My Blog