NetTalk Central

Author Topic: Where to do a SETNULL in an update form?  (Read 3510 times)

Thys

  • Sr. Member
  • ****
  • Posts: 311
    • View Profile
    • Incasu
    • Email
Where to do a SETNULL in an update form?
« 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

Matthew51

  • Full Member
  • ***
  • Posts: 152
    • View Profile
    • Email
Re: Where to do a SETNULL in an update form?
« Reply #1 on: June 14, 2016, 10:45:28 AM »
I've been putting my SetNull at the start of ValidateAll.

Matthew
Contractor with 10+ years of NetTalk experience looking for work.
www.linkedin.com/in/matthew-leavitt
BisWare.ca
Check out my free EasyTime Template

Thys

  • Sr. Member
  • ****
  • Posts: 311
    • View Profile
    • Incasu
    • Email
Re: Where to do a SETNULL in an update form?
« Reply #2 on: June 14, 2016, 10:48:40 AM »
Thanks Matthew. It works.