LiveCode Forums

Just came across this post. The mobile Template is located in the Start Center when you start livecode, bottom right corner.

With the information that Max provided and information from another post on this forum I got the solution. put URL ("binfile:" & specialFolderPath("Documents") & "/myfile.sqlite") into URL ("binfile:" & "mnt/sdcard/myfile.sqlite") This copy the file to the internal memory, I haven't tested put I bel...

Thanks Max

Looks promising. Backup from the Document folder to the sdcard will be real nice, then the user could move the data easily to their computer.

Thanks I will have to see if I can get that working.

I'm fairly new to LC and I have not found a way to backup SQLite from the device. It would also be nice if Google cloud would backup the database with the application. Had user get a new phone and when they setup their new phone the app was installed without moving their data. Kind of useless to bui...

I use specialfolderpath("documents") on mobile devices which works on android and ios. and specialfolderpath("resources") on everything else. If the database does not exist then your code should create the database in that location. The code I posted is exactly what I use on all my devices (PC,Mac,A...

On android the database needs to be in the documents folder, I'm not 100% sure if it has to be in the document folder on ios devices, but it does work in the documents folder. I used the following which works on PC, Macs, android and ios. It will be the database is the same folder as the livecode pr...

The issue that causes the table not to be created is the Foreign Key Reference statement. https://www.sqlite.org/foreignkeys.html

I assume this is not supported in LC.

Klaus

I had tested separate sql statement and didn't have any luck, so I will have to take another look at my sql statements.

I give your code a test too, maybe I can see what I did wrong.

Thanks for the help

Stacy

LiveCode 7.0.6 I can create 1 table in a SQLite Database but I can't seem to get LC to create a second table in the same databases. I have tried the following with the create table combined and I have also use two separate lines and neither has succeeded in creating the images table. The Inventory t...

I got the same results as Pistris, Install LiveCode 7.0.6 and Xcode 6.3 and it worked on ios.

I have same issue, It works on PC, MAC and Android but gives an error on ios. I'm using LIveCode 7.1 (dp1)

I created a new test stack, I place items in the contents manually and ran this sample on my computer and on my android device and the data grid works correctly. If I populate the data grid from a sql database then the data grid stops working correctly on android. You can select items in the data gr...

Klaus Sorry about the typo with your name. I have been using 7.1 but I also download 7.0.6 and tested and I have the same issue. I have also tested the data grid sampler and it works correct on both android and desktop. With new data grid : On the desktop when I select a row it is highlighted and re...

Thanks Klau

I'm getting the same results, it works on my windows desktop machine but not on my android device.

I had declared theLine as a local variable. I also tested as global and got the same results.