Where to do a SETNULL in an update form?

[Thys]

Hi,

I see there is a NetWebServerWorker method called SessionQueueToFile, which I assume is called internally before writing a record to disk. When using MSSQL with FK constraints, I would normally do a SETNULL on some of the fields before the db is updated.

Where then can I do a SETNULL on those fields before it is written to the db?

Thanks,
Thys

[Matthew51]

I've been putting my SetNull at the start of ValidateAll.

Matthew

[Thys]

Thanks Matthew. It works.