I can INSERT all fields as I want to view, and it's update base tables & looks good...
but if I want second time update view's record (when I just insert in view) I can't: when I browse this view it has empty ID_MAIN field (key field) (the same as in main table) but if I close view and reopen it is filled and I can update fields what I want.
My update command:
nRec=recno('main_query') && because id_main is empty
UPDATE main_query SET start=datetime() ;
WHEN recno('main_query')=nRec
Is possible to resolve this ?
but if I want second time update view's record (when I just insert in view) I can't: when I browse this view it has empty ID_MAIN field (key field) (the same as in main table) but if I close view and reopen it is filled and I can update fields what I want.
My update command:
nRec=recno('main_query') && because id_main is empty
UPDATE main_query SET start=datetime() ;
WHEN recno('main_query')=nRec
Is possible to resolve this ?
