NetTalk Central

Author Topic: NWF Auto-Insert  (Read 4500 times)

rupertvz

  • Sr. Member
  • ****
  • Posts: 326
    • View Profile
    • Email
NWF Auto-Insert
« 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.



rupertvz

  • Sr. Member
  • ****
  • Posts: 326
    • View Profile
    • Email
Re: NWF Auto-Insert
« Reply #1 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.


terryd

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
Re: NWF Auto-Insert
« Reply #2 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.
Terry Davidson
Windows 10 64 bit/Windows7 64bit
Clarion 9.1.11529/Clarion10 12567
Nettalk 913
Nettalk 1015
StringTheory267/Winevent515/XFiles298/MessageBox239/Cryptonite186

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: NWF Auto-Insert
« Reply #3 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