>>>>WOW! What a post :o))))))))))))
>>>>In my 22" wide screen monitor it didn't fit :-)))))))
>>>>
>>>>Which field is AUTOINC?
>>>>Just remove it from UpdateNameList.
>>>>
>>>
>>>The first field OptsID is the AutoInc. Let me remove it.
>>>
>>>Also, do I have to specify UpdateCmd, InsertCmd? And InsertRefreshCmd ? I forgot all these details, I think we discussed this before.
>>
>>There is no need except you want to change default CMDs generated by VFP.
>
>How would I know these default commands? Check in run-time?
You could check them in Before* methods (BeforeUpdate, BeforeInsert, BeforeDelete) Last parameter will contain the command.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.