Ed Leafe wrote: > On Nov 17, 2008, at 11:51 PM, Roger Lovelock wrote: > >> SQL for table from SQLite Administrator shown below :- >> >> CREATE TABLE MembershipTypes ( MTypeID INTEGER, MTypeDesc >> VARCHAR2(30) NOT NULL, MTypeDues NUMBER(32,2) NOT NULL, >> primary key (MTypeID)) > > > What version of SQLite is this? These types don't correspond to > current SQLite data types. See > > http://sqlite.org/datatype3.html > > ...for a list of available data types.
With SQLite, you can name the types whatever you want (they are saved as text in sqlite anyway). If you can, I'd change that to MTypeDues DECIMAL (32,2) or something more reasonable like MTypeDues (12,2) (9 places to the left of the decimal point). pysqlite/dabo don't recognize NUMBER, so it makes it unicode. Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]
