On Wednesday 14 February 2007 03:12, Uwe Grauer wrote:
> johnf wrote:
> > On Tuesday 13 February 2007 23:49, P P wrote:
> >> Just starting with dabo .
> >> Database Firebird2.0
> >>
> >> Running Appwizard I see my blob subtype 1 fields identified as bool
> >> and in the browsertab as a checkbox ???
> >> How to display data from a blobfield in a suitable textwidget ?
> >> My blobfields are text blobs which often contain 50 pages worth of text.
> >>
> >> Thanks
> >> Db
> >
> > That's a bug. FireBird is reporting "blob" as a dabotype 'L' but
> > Appwizrd is reporting 'L' as 'bool'
> > typeConversion = {"I" : "int", "C" : "char", "M" : "memo", "D" : "date",
> > "N" : "float", "F" : "float", "?" : "char", "L"
> > : "bool", "B" :
> > "bool", "T" : "datetime"}
> >
> > I'm not sure what is happening with the checkbox - accept to say that is
> > what you would get with a 'bool'.
> >
> > With regard to using blob's in general please review the wiki which has
> > an example of using blob's and MySQL.
>
> Are you sure that it is a bug?
> See the wiki:
> http://dabodev.com/wiki/DataTypes
>
> "Turns out some of the db modules use buffer, some use array.array, some
> use str to represent blobs. I just made "L" map to str, as Python's str
> object can handle any-length binary data just fine."
>
> This should be clarified (bug or not).
>
> Uwe
I don't think it matters if we call it a bug or not. What matters is
dbFirebird.py and Appwizard agree. At the time they did not agree. Of
course Paul has fixed the problem.
This datatype issue is a headache. I would like to add 'list' as a return
value for Postgres's array datatypes. I can add it in dbPostgres.py but what
does the rest of Dabo with the 'list'. Not only that - the datatype 'list'
can be an array of any postgres's datatypes and that includes user defined
types.
That's a headache!
--
John Fabiani
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
