Weird SQLite behavior

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
KennyR
Posts: 256
Joined: Thu Jan 19, 2012 4:25 am

Weird SQLite behavior

Post by KennyR » Mon Feb 17, 2014 5:00 am

Okay....this is not a huge deal but was wondering if anyone has run into this issue. Generally I develop at home on my iMac and then when I go to work I use a Mac mini to develop while I'm there. I just use my drop box to share the .livecode file between locations. I am throwing this out there in effort to cover all my bases in the case this is causing the issue....now to the point.... My SQLite tables and functions work correctly in one location and sometimes not in the other. The code is exactly the same and nothing has changed, it simply won't create the new tables unless I change the name of the table. The funny thing is I never get an error in the script when this happens so it's impossible for me to figure out what's happening! Please tell me I'm not alone in this....any ideas?

MaxV
Posts: 1580
Joined: Tue May 28, 2013 2:20 pm
Contact:

Re: Weird SQLite behavior

Post by MaxV » Mon Feb 17, 2014 1:04 pm

I suppose that it is a permission issue. A file must have "WRITE" permission to create something in it. Probably your your user ID is different on different machines. Check file permissions settings and dropbox configuration.
Livecode Wiki: http://livecode.wikia.com
My blog: https://livecode-blogger.blogspot.com
To post code use this: http://tinyurl.com/ogp6d5w

Post Reply