may be this link help you http://zetcode.com/databases/sqlitetutorial/
On Wed, May 16, 2012 at 2:41 PM, Kostya Vasilyev 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, you need to find
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 ext
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 wrote:
> how about using max(dateUpdated) instead?
>
>
>
>
>
>
>
> On Sunday, May 6,
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),
have the input data ready in a insert friendly way, namely
'Name1','country1'
'Name2','country2'
and then use Begin transaction...Insert loop...commit transaction.
In the insert loop, read your source line by line, and craft the SQL Insert
manually
--
You received this message because you a
ContentValues initialValues = new ContentValues();
initialValues.put("name", namedata);
initialValues.put("country", countrydata);
return mDb.insert(table1, null, initialValues);
On Oct 12, 12:27 am, dipti desai wrote:
> How to insert more than two values in the
Thanks for the answer. But for your information the "item" is not a
float nor a double. It is a reference to an integer defined like this:
"item REFERENCES tbl_items(_id));"
where "_id" is the primary key of another table defined as:
"_id INTEGER PRIMARY KEY AUTOINCREMENT,"
So I'll follow your
I have experienced the same thing.
I'm guessing that item is a float or double, right?
The SQLiteDatabase class doesn't handle floating point properly in
this call. I've had to resort to version 2 in all my calls.
Although this doesn't work properly, I'm not sure it would be
considered a bug bec
8 matches
Mail list logo
