LiveCode Forums

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...

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...

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 ...

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...

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...

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...

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...

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 ...

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...

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...

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...

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...

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).

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...

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...