>1) "Set null" ius scoped to current datasession
>2) Only SQL commands are affected
>Cetin

Is INSERT into myTable from memvar SQL command? In any case, it's affected <g> and I don't know what course of actions to take now... Perhaps I need to switch to insert fields syntax even for Trans table. My original question for the thread was what is faster - insert from memvar or insert fields... I switched to fields almost everywhere, but this means I have to fix the program every time we change the database structure...