Page 1 of 1

SQLIte & create table w/o rowid

Posted: Wed Mar 29, 2023 9:09 pm
by jassing
This code, when using the DLL generates a memory error at program end (after all code, so on dll unload?) (specifically using WITHOUT ROWID)

Code: Select all

UseSQLiteDatabase();"c:\temp\sqlite3.dll") 
Debug OpenDatabase(0, ":memory:","","")
; not using the dll, this line works
; using the dll, it generates a memory error at program end
Debug "Create? "+Str(DatabaseUpdate(0, "CREATE TABLE IncomingData(test TEXT primary key) WITHOUT ROWID;"))
Debug "Error? "+DatabaseError()
Any idea why using the DLL generates a memory error at program end?

pb 6.01x64, win10

Re: SQLIte & create table w/o rowid

Posted: Wed Mar 29, 2023 9:42 pm
by skywalk
Actually, I reported an IMA on PB exit with DLL several years ago.
It was not tied to any specific SQLite command.

Re: SQLIte & create table w/o rowid

Posted: Thu Mar 30, 2023 5:24 am
by jassing
Bummer, so no way to stop it from happening?

I didn't notice it until I added 'Without rowid' then I started getting an error...
Frustrating. thanks.