NetTalk Central

Author Topic: NT14 CLALIT2 - NetwebForm - Duplicate Record  (Read 2414 times)

David

  • Full Member
  • ***
  • Posts: 129
    • View Profile
NT14 CLALIT2 - NetwebForm - Duplicate Record
« on: July 25, 2025, 03:58:52 PM »
I've got a NT14 webserver with a netwebbrowse / form based on a SQLite table using the new Driver Kit.  When I attempt to update a record, the form save returns an error message "creates duplicate record...."  I've attached a screenshot.  The browse and form both use a GUID field as their unique key.  Any suggestions on where to troubleshoot this?  Thank you.

I've done some additional testing....

Change the database driver to TopSpeed, recompile, netwebform functions fine
Change the database driver to SQLite (Softvelocity), recompile, netwebform funtions fine
Change the database driver to SQLite2 (DriverKit), recompile, netwebform presents "creates duplicate record" error
« Last Edit: July 26, 2025, 03:54:45 AM by David »

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11318
    • View Profile
Re: NT14 CLALIT2 - NetwebForm - Duplicate Record
« Reply #1 on: August 03, 2025, 06:28:26 PM »
Hi David,

Please post an example app & dict so I can duplicate here.

And which build of the DriverKit & NetTalk are you using?

Cheers
Bruce

David

  • Full Member
  • ***
  • Posts: 129
    • View Profile
Re: NT14 CLALIT2 - NetwebForm - Duplicate Record
« Reply #2 on: August 06, 2025, 04:56:02 PM »
I updated the NetTalk BasicBrowseAndForm example DCT to user SQLite2 file driver and am getting the error.  Attached is a zip file of the APP, DICT, and SQLite DB.  Try to update either record to see the error.

NT 14.36
DriverKit 1.06

Jane

  • Sr. Member
  • ****
  • Posts: 408
  • Expert on nothing with opinions on everything.
    • View Profile
    • Email
Re: NT14 CLALIT2 - NetwebForm - Duplicate Record
« Reply #3 on: August 06, 2025, 06:17:06 PM »
Confirming that I get the same error as David with driver kit 1.06 and NT 14.34.

Updating a record in the Movies desktop example app from the driver kit works fine, but David's NetTalk form complains of duplicate key.

I didn't chase any further.