NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: rupertvz on August 31, 2017, 12:13:23 AM

Title: NWF Auto-Insert
Post by: rupertvz on August 31, 2017, 12:13:23 AM

Hi Guys,

I have one NWF that inserts a record automatically in the database, even when the form is cancelled by the user (without capturing any details)

I've checked all settings on the form and can't seem to find the reason why this form does auto-insert.

Title: Re: NWF Auto-Insert
Post by: rupertvz on August 31, 2017, 03:09:31 AM

After a bit of digging, I discovered that the auto-insert is caused by one specific field being primed.

After removing the primed value, the form no longer auto-creates a new record.

I am still not sure why this happens, I will in the meantime code the prime value.

Title: Re: NWF Auto-Insert
Post by: terryd on August 31, 2017, 07:40:47 AM

Hi rupert.
If you are using MSSQL the application will prime any field which is part of a unique key.

Title: Re: NWF Auto-Insert
Post by: Bruce on September 01, 2017, 08:42:58 AM

Hi Rupert,

a) do you have an auto-number field in the table?
b) are there child tables (browses) on the form?

cheers
Bruce