Re: [android-developers] Re: SQLITE -query help

2012-05-17 Thread Mahmoud Mortada
may be this link help you http://zetcode.com/databases/sqlitetutorial/ On Wed, May 16, 2012 at 2:41 PM, Kostya Vasilyev kmans...@gmail.com wrote: The query you posted uses Microsoft SQL Server extensions. You can read about them on MSDN. Since Android does not use MS SQL as its database,

[android-developers] Re: SQLITE -query help

2012-05-16 Thread David Hodeffi
i cannot get what do you mean when you say that? and i dont know what the result of this query. my main idea of this query is to get the last round from each game. how can i do that? On May 7, 1:55 am, lbendlin l...@bendlin.us wrote: how about using max(dateUpdated)  instead? On Sunday,

Re: [android-developers] Re: SQLITE -query help

2012-05-16 Thread Kostya Vasilyev
The query you posted uses Microsoft SQL Server extensions. You can read about them on MSDN. Since Android does not use MS SQL as its database, you need to find a way to implement the same logic without these extensions. Understanding the logic is the first step. Reading the MSSQL docs on the

[android-developers] Re: SQLITE -query help

2012-05-06 Thread lbendlin
how about using max(dateUpdated) instead? On Sunday, May 6, 2012 7:56:20 AM UTC-4, David Hodeffi wrote: i have this DB: USERS userId int PK, userName nvarchar(50) GAMES gameId int PK, dateCreated datetime ROUNDS roundId int Pk, gameId int (FK to GAMES), dateCreated