NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Thys on June 14, 2016, 05:37:32 AM

Title: Where to do a SETNULL in an update form?
Post by: Thys on June 14, 2016, 05:37:32 AM
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
Title: Re: Where to do a SETNULL in an update form?
Post by: Matthew51 on June 14, 2016, 10:45:28 AM
I've been putting my SetNull at the start of ValidateAll.

Matthew
Title: Re: Where to do a SETNULL in an update form?
Post by: Thys on June 14, 2016, 10:48:40 AM
Thanks Matthew. It works.