Search found 19 matches

by SChamblee
Thu Oct 01, 2015 5:04 am
Forum: iOS Deployment
Topic: Livecode app2Market template?
Replies: 2
Views: 746

Re: Livecode app2Market template?

Just came across this post. The mobile Template is located in the Start Center when you start livecode, bottom right corner.
by SChamblee
Fri Sep 25, 2015 11:30 pm
Forum: Android Deployment
Topic: Backup sqlite on Android
Replies: 5
Views: 1214

Re: Backup sqlite on Android

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...
by SChamblee
Fri Sep 25, 2015 8:55 pm
Forum: Android Deployment
Topic: Backup sqlite on Android
Replies: 5
Views: 1214

Re: Backup sqlite on Android

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.
by SChamblee
Fri Sep 25, 2015 12:42 am
Forum: Android Deployment
Topic: Backup sqlite on Android
Replies: 5
Views: 1214

Re: Backup sqlite on Android

Thanks I will have to see if I can get that working.
by SChamblee
Thu Sep 24, 2015 3:53 pm
Forum: Android Deployment
Topic: Backup sqlite on Android
Replies: 5
Views: 1214

Backup sqlite on Android

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...
by SChamblee
Wed Aug 26, 2015 9:42 pm
Forum: Databases
Topic: Using Sqlite - Revdberr, invalid database type
Replies: 13
Views: 4264

Re: Using Sqlite - Revdberr, invalid database type

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...
by SChamblee
Wed Aug 26, 2015 6:37 pm
Forum: Databases
Topic: Using Sqlite - Revdberr, invalid database type
Replies: 13
Views: 4264

Re: Using Sqlite - Revdberr, invalid database type

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...
by SChamblee
Mon Aug 24, 2015 8:51 pm
Forum: Databases
Topic: Create SQLite Tables
Replies: 5
Views: 1930

Re: Create SQLite Tables

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.
by SChamblee
Mon Aug 24, 2015 7:12 pm
Forum: Databases
Topic: Create SQLite Tables
Replies: 5
Views: 1930

Re: Create SQLite Tables

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
by SChamblee
Mon Aug 24, 2015 4:25 pm
Forum: Databases
Topic: Create SQLite Tables
Replies: 5
Views: 1930

Create SQLite Tables

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...
by SChamblee
Sun Aug 23, 2015 5:11 am
Forum: iOS Deployment
Topic: revdberr invalid database connection
Replies: 12
Views: 1695

Re: revdberr invalid database connection

I got the same results as Pistris, Install LiveCode 7.0.6 and Xcode 6.3 and it worked on ios.
by SChamblee
Sun Aug 23, 2015 12:47 am
Forum: iOS Deployment
Topic: revdberr invalid database connection
Replies: 12
Views: 1695

Re: revdberr invalid database connection

I have same issue, It works on PC, MAC and Android but gives an error on ios. I'm using LIveCode 7.1 (dp1)
by SChamblee
Sat Aug 15, 2015 6:06 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: DataGrid Question
Replies: 6
Views: 818

Re: DataGrid Question

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...
by SChamblee
Fri Aug 14, 2015 8:07 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: DataGrid Question
Replies: 6
Views: 818

Re: DataGrid Question

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...
by SChamblee
Thu Aug 13, 2015 7:51 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: DataGrid Question
Replies: 6
Views: 818

Re: DataGrid Question

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.

Go to advanced search