Relative paths don't work in LC8, for SQLite?

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
AxWald
Posts: 578
Joined: Thu Mar 06, 2014 2:57 pm

Relative paths don't work in LC8, for SQLite?

Post by AxWald » Wed Apr 06, 2016 2:44 pm

Hi,

to save you the time I've lost: :evil:

It seems that LC8 doesn't support relative paths anymore when connecting to a SQLite db.
It gives you a proper looking connectionID at "revopendatabase", but any subsequent calls to "revdatafromquery" or "revdb_execute" will fail with "no such table ..."
- obviously the connectionID delivered is a fake.

Save yourself the time & use absolute paths now! Try yourself with the attached stack! Tested on Win & Linux.

Have fun!
Attachments
LCSQLITE_test.zip
A little test stack
(4.45 KiB) Downloaded 243 times
All code published by me here was created with Community Editions of LC (thus is GPLv3).
If you use it in closed source projects, or for the Apple AppStore, or with XCode
you'll violate some license terms - read your relevant EULAs & Licenses!

jacque
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 7257
Joined: Sat Apr 08, 2006 8:31 pm
Location: Minneapolis MN
Contact:

Re: Relative paths don't work in LC8, for SQLite?

Post by jacque » Wed Apr 06, 2016 4:35 pm

If it used to work and now it doesn't, it's a bug. Please enter a bug report and include the sample stack.
Jacqueline Landman Gay | jacque at hyperactivesw dot com
HyperActive Software | http://www.hyperactivesw.com

AxWald
Posts: 578
Joined: Thu Mar 06, 2014 2:57 pm

Re: Relative paths don't work in LC8, for SQLite?

Post by AxWald » Wed Apr 06, 2016 4:54 pm

Hi,

done. Bug report

Edit: The ReadMe in the attachment is wrong. Replace Win 7 with Win 10 ;-)

Have fun!
All code published by me here was created with Community Editions of LC (thus is GPLv3).
If you use it in closed source projects, or for the Apple AppStore, or with XCode
you'll violate some license terms - read your relevant EULAs & Licenses!

Post Reply

Return to “Databases”