PB 6.40 (x64) Beta 1 SQLite database error

[mbierly]

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

[mk-soft]

Please post executable pseudo code.

[Fred]

Any chance to have a working snippet showing the issue ?