SQLIte & create table w/o rowid

Just starting out? Need help? Post your questions and find answers here.
jassing
Addict
Addict
Posts: 1745
Joined: Wed Feb 17, 2010 12:00 am

SQLIte & create table w/o rowid

Post 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
User avatar
skywalk
Addict
Addict
Posts: 3972
Joined: Wed Dec 23, 2009 10:14 pm
Location: Boston, MA

Re: SQLIte & create table w/o rowid

Post by skywalk »

Actually, I reported an IMA on PB exit with DLL several years ago.
It was not tied to any specific SQLite command.
The nice thing about standards is there are so many to choose from. ~ Andrew Tanenbaum
jassing
Addict
Addict
Posts: 1745
Joined: Wed Feb 17, 2010 12:00 am

Re: SQLIte & create table w/o rowid

Post 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.
Post Reply