Retrieving AutoInc or default fields when using cursoradapters

[sklewis]

I'm using cursor adapters with an underlying table that has default values for the primary key field and date fields. Is there an easy way to retrieve this information when I append a blank? This is in VFP 9 sp1

caCustomer - cursor adapter on customer table
customer - customer table
custID - autoinc field in customer
dateadded - default value of DATE() in customer table

How can I retrieve the custID from the base table? Are there any automatic methods? or do I have to specifically set caCustomer.custID = customer.custId? If this is so, how do I upgrade to non native VFP data server?

HELP!!!!

I read some info in this post but it didn't help me.
thread184-799513 mheit referenced in one of his posts that VFP 9 supported this automatically but I still haven't figured it out.

 

[TamarGranor]

See whether the GetAutoIncValue() function will help you.

Tamar