Search found 33 matches

by chuckm
Mon Feb 25, 2019 9:15 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: SQLite Questions
Replies: 32
Views: 1460

Re: SQLite Questions

Absolute paths, absolutely! :D Kinda kidding, but Klaus does have a point. The lessons I linked to were more than I do when looking for paths, except in certain circumstances. MOSTLY, they are just very thorough. As a couple of examples, lets say I had a folder my app is in, and wanted to go one mo...
by chuckm
Mon Feb 25, 2019 8:30 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: SQLite Questions
Replies: 32
Views: 1460

Re: SQLite Questions

I'm using this and works good: on preOpenStack if the platform is "Linux" then put specialFolderPath("home") & "/myDB.sqlite" into gDatabasePath else put specialFolderPath("support") & "/myDB.sqlite" into gDatabasePath end if end if put revOpenDatabase("sqlite", gDatabasePath, , , , ) into gLocalDb...
by chuckm
Mon Feb 25, 2019 7:15 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: SQLite Questions
Replies: 32
Views: 1460

Re: SQLite Questions

As I mentioned in my first post, my initial thought was the message handler needed to go into the stack, but apparently it needs to go into the first card. Not exactly. Most messages will be sent to the card, but they pass along the message path from there. The path is a little snakey depending on ...
by chuckm
Mon Feb 25, 2019 7:03 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: SQLite Questions
Replies: 32
Views: 1460

Re: SQLite Questions

It turns out that I needed to use a backslash instead of a forward slash in the relative path. I work under Unix (MacOS, Linux) a lot more than I do Windows so it didn't occur to me that the path delimiter would be the issue. I actually found it by trial and error before I found anything from searc...
by chuckm
Sat Feb 23, 2019 7:49 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: SQLite Questions
Replies: 32
Views: 1460

Re: SQLite Questions

It turns out that I needed to use a backslash instead of a forward slash in the relative path. I work under Unix (MacOS, Linux) a lot more than I do Windows so it didn't occur to me that the path delimiter would be the issue. I actually found it by trial and error before I found anything from searc...
by chuckm
Fri Feb 22, 2019 5:33 am
Forum: Getting Started with LiveCode - Experienced Developers
Topic: SQLite Questions
Replies: 32
Views: 1460

Re: SQLite Questions

If the default folder is pointing to the location that contains your "data" folder, I think it should locate and open up your database correctly. If this is happening in the IDE, its likely that the default folder is pointing to a wrong, and likely un-writeable location. Check to see what the defau...
by chuckm
Fri Feb 22, 2019 1:58 am
Forum: Getting Started with LiveCode - Experienced Developers
Topic: SQLite Questions
Replies: 32
Views: 1460

Re: SQLite Questions

Hi!, I had pointed them to most of those resources and I know that at least half of them worked through a lot of the online materials. For whatever reason, they came away pretty frustrated and came to the conclusion, right or wrong, that there was more of a future with Python or Javascript/Node.js a...
by chuckm
Thu Feb 21, 2019 10:47 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: SQLite Questions
Replies: 32
Views: 1460

Re: SQLite Questions

The initial problem may be somewhat solved although I'm a little mystified (looking through the dictionary for an explanation right now). The forward slash that separates the filename from the containing directory name apparently should have been a backslash. I work mostly under Unix so this didn't ...
by chuckm
Thu Feb 21, 2019 10:12 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: SQLite Questions
Replies: 32
Views: 1460

Re: SQLite Questions

You've just answered your own questions. Well, except this one - Is it better to create a single global connection to the database or to open and close the database for each query? My gut feeling is that it probably doesn't matter, but it would seem that opening a single global connection for the d...
by chuckm
Thu Feb 21, 2019 9:57 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: SQLite Questions
Replies: 32
Views: 1460

Re: SQLite Questions

You've just answered your own questions. Open the DB when opening the stack close it when closing the stack If it does not exist, create it So, I just added the following code to the first card per the openStack Api in the docs: on openStack global gConId put revOpenDatabase("sqlite", "data/databas...
by chuckm
Thu Feb 21, 2019 9:45 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: SQLite Questions
Replies: 32
Views: 1460

Re: SQLite Questions

However, LC continues to be far more challenging to create apps with than any of my other alternatives (which is why I'm focusing on it again). I am curious. Do you mean that LC per se is challenging, or that its support of and interaction with SQLite is? I cannot believe it can possibly be the for...
by chuckm
Thu Feb 21, 2019 12:38 am
Forum: Getting Started with LiveCode - Experienced Developers
Topic: SQLite Questions
Replies: 32
Views: 1460

SQLite Questions

Hi All, After having to be away for over a year or so, I'm back to trying to suss out how to best work with LC. My current project is to create a SQLite database driven program that allows users to enter data into simple tables and then use that data to create complex collections using one-to-many a...
by chuckm
Sat Sep 02, 2017 3:07 am
Forum: Talking LiveCode
Topic: Hypercard on Archive.org
Replies: 3
Views: 1128

Hypercard on Archive.org

I didn't know if anyone had posted this, but I saw an article about HyperCard on the archive from the archive.org site (https://archive.org/details/hypercardstacks).
by chuckm
Tue Aug 29, 2017 7:14 am
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Looking for an example stack of a address book, etc.
Replies: 70
Views: 7237

Re: Looking for an example stack of a address book, etc.

I seem to remember the recommendation wasn't to hide them, but simply disable them, but I could be wrong. Interestingly enough, I did find two topics on the byu site that are pertinent to two of the questions asked er, earlier, while trying to find something else entirely. http://livecode.byu.edu/d...
by chuckm
Mon Aug 28, 2017 7:52 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Looking for an example stack of a address book, etc.
Replies: 70
Views: 7237

Re: Looking for an example stack of a address book, etc.

Heh, I can well understand the 'nix philosophy, but I wasn't talking about sticking that in the buttons script. That kind of code would go much lower, card or, in the case of your address book where there are a LOT of cards, stack level script. I would point out that you could easily use the method...

Go to advanced search