[Dbix-class] DBF access ?

[Alan Humphrey]

> -----Original Message-----
> From: Erik Colson [mailto:eco at ecocode.net]
> Sent: Monday, January 28, 2008 10:19 AM
> To: DBIx::Class user and developer list
> Subject: Re: [Dbix-class] DBF access ?
> 
> On Fri, Jan 25, 2008 at 08:31:17AM +0000, Matt S Trout wrote:
> > On Fri, Jan 25, 2008 at 07:52:20AM +0100, Erik Colson wrote:
> > > Hello
> > >
> > > I'm using DBIx::Class for accessing data in Mysql which does work
> great.
> > > I now would like to use DBIx::Class with DBF (Foxpro or DBase data
> files).
> > > Is this possible ? What would be the best approach ? Would there be
> some limitations ?
> >
> > If there's a DBD then it probably is possible, though you may need to
> write
> > something to handle last_insert_id work since IME that's different
> with every
> > DBD ...
> 
> The best way seems to use DBD::ODBC on a windows platform and then use
> the foxpro driver.
> however I'm falling into this problem :
> 
> DBIx::Class does generate SELECT statements like this :
> 
>   SELECT me.field FROM table me WHERE (me.field=?) :'a_key'
> 
> This is not accepted by the foxpro driver which wants :
> 
>   SELECT me.field FROM table me WHERE (me.field='a_key')
> 
> So, I can circumvent this problem by useing search_literal, but this
> stops working when DBIx::Class magic starts most of its magic.
> Therefor I'm searching for a way to add the possibility to change the
> SQL layout.. is this already implemented somewhere? if not, where
> should I do this ?
> 
> Thanks for help
> 
> --
> Erik
> 

Have a look at DBIx::Class::Storage::DBI::Sybase.  It uses
DBIx::Class::Storage::DBI::NoBindVars to solve the same problem for Sybase.

- Alan