I have dug back and I originally converted the database to SQLite3 using a
conversion utility which generated an SQL script. Looking at the script the
data types of the three fields were:-
MTypeID INTEGER
MTypeDesc VARCHAR2(30) NOT NULL
MTypeDues NUMBER(32,2) NOT NULL
primary key (MTypeID)
There are three test records in the database, which has been working fine
with both c# and boo programs. Correct data is shown with dabo, I just get
that message. I thought that there was something about all data being stored
in SQLite as char strings, so maybe the problem is with the interpretation
of the SQLite schema?
Rodgy
----- Original Message -----
From: "Ed Leafe" <[EMAIL PROTECTED]>
To: "Dabo Users list" <[email protected]>
Sent: Wednesday, November 19, 2008 2:32 AM
Subject: Re: [dabo-users] Data Types in bizObj
> 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.
>
>
> -- Ed Leafe
>
>
>
>
>
[excessive quoting removed by server]
_______________________________________________
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]
