Search found 37 matches

by mattrgs
Wed Apr 16, 2014 8:36 pm
Forum: Android Deployment
Topic: Android and MySQL
Replies: 3
Views: 920

Re: Android and MySQL

Thanks, took a bit of time to find all of the correct boxes to tick but it now works! :D
by mattrgs
Wed Apr 16, 2014 4:48 pm
Forum: Android Deployment
Topic: Android and MySQL
Replies: 3
Views: 920

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
by mattrgs
Sun Apr 13, 2014 9:13 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Sorting and saving datagrid
Replies: 5
Views: 789

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...
by mattrgs
Sun Apr 13, 2014 8:18 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Sorting and saving datagrid
Replies: 5
Views: 789

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
by mattrgs
Sun Apr 13, 2014 7:39 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Sorting and saving datagrid
Replies: 5
Views: 789

Re: Sorting and saving datagrid

Thanks, I wandered if this was possible
How would I include these in my code?
Thanks
Matthew
by mattrgs
Sun Apr 13, 2014 7:19 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Sorting and saving datagrid
Replies: 5
Views: 789

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...
by mattrgs
Mon Feb 24, 2014 1:06 pm
Forum: Android Deployment
Topic: Online Leaderboard
Replies: 7
Views: 1908

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.
by mattrgs
Mon Feb 24, 2014 9:54 am
Forum: Android Deployment
Topic: Online Leaderboard
Replies: 7
Views: 1908

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 ...
by mattrgs
Sun Feb 23, 2014 8:54 pm
Forum: Talking LiveCode
Topic: A Public Highscore System
Replies: 3
Views: 979

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
by mattrgs
Sun Feb 23, 2014 8:00 pm
Forum: Android Deployment
Topic: Online Leaderboard
Replies: 7
Views: 1908

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...
by mattrgs
Sun Feb 23, 2014 4:15 pm
Forum: Android Deployment
Topic: Online Leaderboard
Replies: 7
Views: 1908

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...
by mattrgs
Sat Feb 22, 2014 10:16 pm
Forum: Talking LiveCode
Topic: A Public Highscore System
Replies: 3
Views: 979

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 ...
by mattrgs
Sat Feb 22, 2014 3:53 pm
Forum: Android Deployment
Topic: App slows down with 'Wait with messages"
Replies: 7
Views: 1334

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.
by mattrgs
Sat Feb 22, 2014 2:58 pm
Forum: Android Deployment
Topic: App slows down with 'Wait with messages"
Replies: 7
Views: 1334

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...
by mattrgs
Fri Feb 21, 2014 8:20 pm
Forum: Android Deployment
Topic: App slows down with 'Wait with messages"
Replies: 7
Views: 1334

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

Go to advanced search