NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: David on July 25, 2025, 03:58:52 PM

Title: NT14 CLALIT2 - NetwebForm - Duplicate Record
Post by: David 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

Title: Re: NT14 CLALIT2 - NetwebForm - Duplicate Record
Post by: Bruce 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

Title: Re: NT14 CLALIT2 - NetwebForm - Duplicate Record
Post by: David 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

Title: Re: NT14 CLALIT2 - NetwebForm - Duplicate Record
Post by: Jane 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.