On Mon, Apr 16, 2012 at 10:31 AM, George <[email protected]> wrote:
> On 4/16/12, Richard Hipp <[email protected]> wrote: > > On Mon, Apr 16, 2012 at 9:43 AM, George <[email protected]> wrote: > > > >> > >> create table if not exists SnapshotsMarketsRunners( > >> ID integer primary key, > >> SnapshotsID integer not null references Snapshots(ID), > >> MarketsRunnersID not null references MarketsRunners(ID), > >> > > > > Specify type "integer" on the MarketRunnersID column > > > > Thanks, it works now. I had omitted the type name by mistake. I assume > that the absence of data type specification means that the column can > accept any data, is this correct? > Correct. That means that you could have inserted a string '123' instead of a number 123, and the string form would have been retained. And because of that, the index could not bee used to do the lookup. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
