PB 6.40 (x64) Beta 1 SQLite database error
Posted: Wed Mar 04, 2026 4:55 am
The code snippet below works kind of in 6.40 Beta 1. It writes the record into the table but the debugger unexpectedly quits when running in the IDE. When running the compiled app it just quits. This same code in 6.30 writes the record and continues on in the program. The project is running with the default compiler options.
Code: Select all
Protected SqlStmt.s = "INSERT INTO Registration(FirstName, LastName, Company, RegistrationNumber, TrialStartDate, RegistrationDate, VersionInfo) VALUES(?, ?, ?, ?, ?, ?, ?)"
Protected DbResult.q
SetDatabaseString(DbCnn::Cnn, 0, "Unregistered")
SetDatabaseString(DbCnn::Cnn, 1, "Unregistered")
SetDatabaseString(DbCnn::Cnn, 2, "Unregistered")
SetDatabaseString(DbCnn::Cnn, 3, "Unregistered")
SetDatabaseQuad(DbCnn::Cnn, 4, Date())
SetDatabaseQuad(DbCnn::Cnn, 5, 0)
SetDatabaseString(DbCnn::Cnn, 6, "V0.1.0")
DbResult = DatabaseUpdate(DbCnn::Cnn, SqlStmt)
If DbResult <= 0
Debug DatabaseError()
EndIf