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

Creating desktop or client-server database solutions?

Moderators: Klaus, FourthWorld, heatherlaine, robinmiller, kevinmiller

Post Reply
AxWald
Posts: 390
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 65 times
Livecode programming until the cat hits the fan ...

jacque
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 5227
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: 390
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!
Livecode programming until the cat hits the fan ...

Post Reply

Return to “Databases”