Re: Gtk2-Ex-Datasheet-DBI-0.8 and SQLite

[Daniel Kasak <dan entropy homelinux org>]

Gábor Szabó wrote:

> I am trying to write a small demo using  Gtk2-Ex-Datasheet-DBI-0.8 and SQLite
> but it seems SQLite does not know what to do with this call:
>
> $self->{dbh}->column_info
>
> therefore I had to hardcode the information about my database into the module.
>
> the sample application is at
> http://svn1.hostlocal.com/szabgab/trunk/gtk2/dbi/phonebook/
> including the module with the hard coded columns
> http://svn1.hostlocal.com/szabgab/trunk/gtk2/dbi/phonebook/lib/Gtk2/Ex/Datasheet/DBI.pm
>
> Is there a better way to handle this ?
>
>  
I haven't used SQLite before so I don't know if it supports calling 
$dbh->column_info or not. The docs for other DBD modules said that they 
do, so I assumed it was OK to go ahead assuming this behaviour. If you 
need something working *now*, then have a look at Gtk2-Ex-Datasheet-0.7. 
Version 0.8 was largely a bugfix release, as well as fixing some 
behind-the-scenes stuff for later. The only real feature addition was 
the automatic detection of field types ( and selection of renderers ), 
so if this is what's tripping you up, then just don't use it - go back 
to 0.7 for now.

If you can get some word from the SQLite people on any possible ways of 
fetching a schema via their DBD module, then I'll try to add support. 
Alternatively, I can disable the field type detection for SQLite if we 
can't find another way around it.

Dan


--
BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------If you are not the CanIt administrator and you think 
this
message is spam, please give the id 7240 and magic value
433d572c6587 to postmaster entropy homelinux org to be marked as spam.

Teach CanIt if this mail (ID 7240) is spam:
Spam:        http://entropy.homelinux.org/canit/b.php?c=s&i=7240&m=433d572c6587
Not spam:    http://entropy.homelinux.org/canit/b.php?c=n&i=7240&m=433d572c6587
Forget vote: http://entropy.homelinux.org/canit/b.php?c=f&i=7240&m=433d572c6587
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS