I was using SQLExec() [SPT]. This is only a problem when adding new records. You could define a default value for every field even if it is only ''. Specify {} as the default for date fields, etc.
>It is a function in the dbc. I can open the table in VFP and add or insert a record and it works fine every time. I am using ado too if this complicates things.
>
>I wonder if I have a different version of the odbc driver by chance.. I shouldn't since I don't think I would have installed anything that would have used an older version since I have installed VFP 6 on this machine.
>
>>>How are those of you that use the VFP ODBC driver and DBC's generating your primary keys since the "Default Value" is not honored and it will not fire the stored procedure?
>>>
>>>Tommy
>>
>>Works fine for me. Is your default value of the PK field a function call to your DBC'S SPs? The only requirement is I have to submit values for all fields in the table except for the ones than have a default value specified for them.
Mark McCasland
Midlothian, TX USA