Gerhard Haering wrote: Where did you get this interesting syntax with AFFINITY from?
Check out http://www.sqlite.org/cvstrac/getfile/sqlite/doc/affinity.html
Clay Dowling wrote: Try this instead: CREATE TABLE Orders (OrderID int, CustomerID varchar(5));
Of course I could try it. However, I'd like to tell sqlite myself the each column's affinity.
And, according to the docs, the syntax I'm using is supported.
Regards, George Ionescu
_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar - get it now! http://toolbar.msn.com/