Search found 37 matches
- Wed Apr 16, 2014 8:36 pm
- Forum: Android Deployment
- Topic: Android and MySQL
- Replies: 3
- Views: 2508
Re: Android and MySQL
Thanks, took a bit of time to find all of the correct boxes to tick but it now works!
- Wed Apr 16, 2014 4:48 pm
- Forum: Android Deployment
- Topic: Android and MySQL
- Replies: 3
- Views: 2508
Android and MySQL
Hi everyone,
I am creating an app which uses an SQL database. When I run the code on my phone it stops working when I try to make a connection with the database, I have run the code on my computer and it works. Any suggestions?
Thanks
Matthew
I am creating an app which uses an SQL database. When I run the code on my phone it stops working when I try to make a connection with the database, I have run the code on my computer and it works. Any suggestions?
Thanks
Matthew
- Sun Apr 13, 2014 9:13 pm
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Sorting and saving datagrid
- Replies: 5
- Views: 2984
Re: Sorting and saving datagrid
In the end I did it slightly differently, as I realised that I wanted to do the ranking in a slightly different way that isn't possible with MySQL. For anyone's future interest here is my code with the table and column name emited: put "SELECT * FROM " & tTableName & " ORDER BY tColumnName DESC" int...
- Sun Apr 13, 2014 8:18 pm
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Sorting and saving datagrid
- Replies: 5
- Views: 2984
Re: Sorting and saving datagrid
I have entered it, and it returns this error code:
revdberr,You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '‘rank’, p.* from tTableName p, (SELECT @rownum:=0) r order by Score desc' at line 1
revdberr,You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '‘rank’, p.* from tTableName p, (SELECT @rownum:=0) r order by Score desc' at line 1
- Sun Apr 13, 2014 7:39 pm
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Sorting and saving datagrid
- Replies: 5
- Views: 2984
Re: Sorting and saving datagrid
Thanks, I wandered if this was possible
How would I include these in my code?
Thanks
Matthew
How would I include these in my code?
Thanks
Matthew
- Sun Apr 13, 2014 7:19 pm
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Sorting and saving datagrid
- Replies: 5
- Views: 2984
Sorting and saving datagrid
Hi, I have a datagrid which downloads the contents of a MySQL database table, this is downloaded with the entries in no particular order. The table has a name column and a score column. In the datagrid I want it to be sorted by the score (descending). This can be done easily, but here comes the prob...
- Mon Feb 24, 2014 1:06 pm
- Forum: Android Deployment
- Topic: Online Leaderboard
- Replies: 7
- Views: 5328
Re: Online Leaderboard
Simon,
I have tested your suggestion just using a field rather than saving the results to a file, however I was hoping to be able to create a leaderboard which contained all entries, not just the top 3. Sorry if I caused confusion.
I have tested your suggestion just using a field rather than saving the results to a file, however I was hoping to be able to create a leaderboard which contained all entries, not just the top 3. Sorry if I caused confusion.
- Mon Feb 24, 2014 9:54 am
- Forum: Android Deployment
- Topic: Online Leaderboard
- Replies: 7
- Views: 5328
Re: Online Leaderboard
Thanks Simon, to clarify I want a leaderboard which can be updated which appears within the app. Could you please provide some guidance on how I would do it with SQL, I know there are lessons on how to upload etc. but how would I insert the records, as if it was listed in the correct order on mySQL ...
- Sun Feb 23, 2014 8:54 pm
- Forum: Talking LiveCode
- Topic: A Public Highscore System
- Replies: 3
- Views: 2851
Re: A Public Highscore System
Thanks, but unfortunately this is only for iOS, and I am currently mainly developing for Android so this wouldn't work. I am going to move onto iOS hopefully and I would then use this, but currently I don't have a Mac so can't develop for iOS. Does anyone have suggestions for Android?
Thanks
Matthew
Thanks
Matthew
- Sun Feb 23, 2014 8:00 pm
- Forum: Android Deployment
- Topic: Online Leaderboard
- Replies: 7
- Views: 5328
Re: Online Leaderboard
Would anyone be willing to provide some guidance on this, as although I am quite proficient in coding I am not confident with databases and webpages etc. Even just to maybe explain the structure of how I should run it, as I don't want to have to overcomplicate my app if it means having to download a...
- Sun Feb 23, 2014 4:15 pm
- Forum: Android Deployment
- Topic: Online Leaderboard
- Replies: 7
- Views: 5328
Online Leaderboard
Hi everyone, I have been creating a game for Android and I would like to implement a public leaderboard. I was wandering if anyone could offer any suggestions in how to go about this. The ideal one would be to be able to use google play services, as this could then also be used for iOS, however I do...
- Sat Feb 22, 2014 10:16 pm
- Forum: Talking LiveCode
- Topic: A Public Highscore System
- Replies: 3
- Views: 2851
A Public Highscore System
Hi everyone, I have created a game which is designed for mobile. For this I want to implement a high score system, this needs to be both local and also public: 1) Local - I know that this should be quite easy, I have tried to save the stack, using a splash stack with the other stack attached, shown ...
- Sat Feb 22, 2014 3:53 pm
- Forum: Android Deployment
- Topic: App slows down with 'Wait with messages"
- Replies: 7
- Views: 3984
Re: App slows down with 'Wait with messages"
Thanks, I got that to work, I wasn't sure where to find the font files, so I found it easiest just to download one from online.
- Sat Feb 22, 2014 2:58 pm
- Forum: Android Deployment
- Topic: App slows down with 'Wait with messages"
- Replies: 7
- Views: 3984
Re: App slows down with 'Wait with messages"
Thanks Simon and Dixie As far as I can see both of your suggested codes are very similar, is there any advantages to one over another? On a slightly unrelated point when I did transfer the app to my phone all off the fonts which I had set had been lost, is there any reason for this and a way to solv...
- Fri Feb 21, 2014 8:20 pm
- Forum: Android Deployment
- Topic: App slows down with 'Wait with messages"
- Replies: 7
- Views: 3984
Re: App slows down with 'Wait with messages"
Instead of 'wait 1 second with messages', try... wait 0 millisecs with messages if all you are wanting to do it wait for the liveCode engine to execute everything Hi Dixie, I still want to keep the waiting for 1 second as I need to count down for 30 seconds, so I don't think this would work. If I d...