Sqlite runtime dll for PB 4.20?

Everything else that doesn't fall into one of the other PB categories.
dell_jockey
Enthusiast
Enthusiast
Posts: 767
Joined: Sat Jan 24, 2004 6:56 pm

Sqlite runtime dll for PB 4.20?

Post by dell_jockey »

Hi Group,

yesterday I noticed that there's no SQLITEx.DLL in my PB4.20 directory tree. Don't we need to pack it with our applications anymore? That would be great! ;)
cheers,
dell_jockey
________
http://blog.forex-trading-ideas.com
Mistrel
Addict
Addict
Posts: 3415
Joined: Sat Jun 30, 2007 8:04 pm

Post by Mistrel »

There is a sqlite3.lib in the PureLibraries\Windows\Libraries folder. The functions appear to be statically linked now (yay!).
dell_jockey
Enthusiast
Enthusiast
Posts: 767
Joined: Sat Jan 24, 2004 6:56 pm

Post by dell_jockey »

Indeed, that's the one I found too. Statically linked now... COOL, c'est très très bon!
Thanks PureTeam! ;)
cheers,
dell_jockey
________
http://blog.forex-trading-ideas.com
NSaneBMX
New User
New User
Posts: 4
Joined: Fri Mar 28, 2008 11:12 pm

Post by NSaneBMX »

Yeah, Thanks!!! (...)
User avatar
pdwyer
Addict
Addict
Posts: 2813
Joined: Tue May 08, 2007 1:27 pm
Location: Chiba, Japan

Post by pdwyer »

Does anyone know how to get to the other functions in there? Or can you only access it through database functions that PB has exported?
Paul Dwyer

“In nature, it’s not the strongest nor the most intelligent who survives. It’s the most adaptable to change” - Charles Darwin
“If you can't explain it to a six-year old you really don't understand it yourself.” - Albert Einstein
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 »

You can import all functions like here: http://www.purebasic.fr/english/viewtop ... 853#240853
but you can't mix this without the handle to the database
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
User avatar
pdwyer
Addict
Addict
Posts: 2813
Joined: Tue May 08, 2007 1:27 pm
Location: Chiba, Japan

Post by pdwyer »

but this is going to need a dll too isn't it? (I'm not very experienced with using libs) If we use PB's commands to open a DB and then want to use some other SQLite function out of that lib, can we? (assuming we can find DB and statement handles at some stage)
Paul Dwyer

“In nature, it’s not the strongest nor the most intelligent who survives. It’s the most adaptable to change” - Charles Darwin
“If you can't explain it to a six-year old you really don't understand it yourself.” - Albert Einstein
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 »

> but this is going to need a dll too isn't it?
No, this using the static lib, no dll!
Only the older wrapper in the thread using a dll
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
User avatar
pdwyer
Addict
Addict
Posts: 2813
Joined: Tue May 08, 2007 1:27 pm
Location: Chiba, Japan

Post by pdwyer »

I didn't notice that addition!

Thanks
Paul Dwyer

“In nature, it’s not the strongest nor the most intelligent who survives. It’s the most adaptable to change” - Charles Darwin
“If you can't explain it to a six-year old you really don't understand it yourself.” - Albert Einstein
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 »

Code: Select all

UseSQLiteDatabase()

ImportC "" 
First line is command for pbcompiler to import the static lib and
in the second command we can use "" for import :wink:
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