Thanks, sounds right, I'll give it a go and let you know!
Rodgy
----- Original Message -----
From: "Paul McNett" <[EMAIL PROTECTED]>
To: "Dabo Users list" <dabo-users@leafe.com>
Sent: Wednesday, November 19, 2008 3:20 AM
Subject: Re: [dabo-users] Data Types in bizObj
> 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
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: Dabo-users@leafe.com
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]
