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?
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to