[Implemented] SQlite3 create database and inmemory database

Got an idea for enhancing PureBasic? New command(s) you'd like to see?
User avatar
ts-soft
Always Here
Always Here
Posts: 5756
Joined: Thu Jun 24, 2004 2:44 pm
Location: Berlin - Germany

[Implemented] SQlite3 create database and inmemory database

Post by ts-soft »

I wish that OpenDatabase supports to create a New Database, like SQlite3 do
it and support InMemory Databases (OpenDatabase(1, ":memory:", "", ""))

greetings
Thomas
PureBasic 5.73 | SpiderBasic 2.30 | Windows 10 Pro (x64) | Linux Mint 20.1 (x64)
Old bugs good, new bugs bad! Updates are evil: might fix old bugs and introduce no new ones.
Image
Fred
Administrator
Administrator
Posts: 18162
Joined: Fri May 17, 2002 4:39 pm
Location: France
Contact:

Post by Fred »

It should work, as OpenDatabase uses sqlite3_open(), could you check that ?
User avatar
ts-soft
Always Here
Always Here
Posts: 5756
Joined: Thu Jun 24, 2004 2:44 pm
Location: Berlin - Germany

Post by ts-soft »

Fred wrote:It should work, as OpenDatabase uses sqlite3_open(), could you check that ?
I have checked this, but become only 0 as result!
With API it works, but than i have no PB Object

I think you have a "FileExists" check, but this should remove for sqlite3

You can open emptyfilename "", ":memory:", this works with the API
PureBasic 5.73 | SpiderBasic 2.30 | Windows 10 Pro (x64) | Linux Mint 20.1 (x64)
Old bugs good, new bugs bad! Updates are evil: might fix old bugs and introduce no new ones.
Image
Post Reply