Hi All,

Up until now to add a new record to the database I would retrieved an empty cursor from the database. I would ask for a record where the numeric field that is the primary index was equal to 0. This way I would have a cursor with the structure I needed. Then just add a blank record. Add the data and save it. Now they tell me that they want to allow internal numbers to be 0 or even negative numbers???

What I’d like to know is. What is the best way to approach this? I still need a cursor with no records.

I'm using VFP6 SP3 to access a VFP database through the VFP ODBC driver.

TIA
Mike