Re: [sqlite] How do I write a query

2013-03-23 Thread Simon Slavin
On 24 Mar 2013, at 5:03am, Igor Korot wrote: > When application starts I need to retrieve first all available players > and then all players that are drafted. > > Probably the easiest way would be to query playersinleague for all > players and then query draftedplayers for all drafted players.

[sqlite] How do I write a query

2013-03-23 Thread Igor Korot
Hi, ALL, CREATE TABLE players( playerid integer primary key, name ); CREATE TABLE league( leagueid integer primary key, name ); CREATE TABLE playersinleague( playerid integer, leagueid integer, price double, foreign key playerid references players(playerid), foreign key leagueid references league(l

Re: [sqlite] Change a field type

2013-03-23 Thread Simon Slavin
On 23 Mar 2013, at 4:07pm, Marco Turco wrote: > I have a table with one field defined as smallint(3) and I would like to > change the field type now in char(3) (without lost the value inside). > > How can I make the change ? Do I need to create a new table with the new > fields where import the

[sqlite] Change a field type

2013-03-23 Thread Marco Turco
Hi, I have a table with one field defined as smallint(3) and I would like to change the field type now in char(3) (without lost the value inside). How can I make the change ? Do I need to create a new table with the new fields where import the current data or is there a better method ? Thanks

Re: [sqlite] atof1 and sysfault test failures

2013-03-23 Thread alw
fir the sysfault tests : sysfault-2.1-vfsfault-transient tests fails with "disk I/O Error". I have noticed that the failure happens at ftruncate() syscall at the test test_syscall install {open ftruncate close read pread pread64 write fallocate} below sequence of lines are executed Breakpoint