Hi Boris,

I checked the generated commands and they are

UPDATE DealerOpts SET RETAIL=curdealeropts.retail WHERE OPTSID IS NULL AND RETAIL IS NULL

Obviously it would not work.

I'm thinking, I need to come up with the different solution - but not exactly know yet. In my select I need to use INNER JOIN (not left or right join).

Then I need to execute some code after CursorFill to insert extra records (which are not yet in my table) for selected models.

Do you know what method should I hook to do some extra code and how exactly should I program it?

Thanks again.

>>>>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.