--- In Firebird-general@yahoogroups.com, Philippe Makowski
<makowski@...> wrote:

>
> Le 28/09/2006 16:44, Uwe Grauer a dit :
> > I looked briefly into the code and i don't think that it is easy!
> you are certainly right
>
> > They used create and alter table statements in code.
> > Doing DDL in Fb isn't recommended in runtime.
> > Also, i saw a lot of sql without using parameters.
> > This calls for sql injections.
> >
> They are doing so only for upgrading the application or adding a new

module

> But we can manage it another way if need.
> or find another CRM ERP software to move to Firebird ;)
>

First work (after porting the DB DDL) would be to modify the
connection to Postgre part of the code to be able to connect to FB.

I had a look to the SQL, it seems in most cases compatible with
firebird sql syntax, buts some changes will have to be done for:
- field::numeric(16,2)
- boolean syntax (where field) or (field=TRUE)
- COALESCE()
- order by field limit x offset y
- and probably some timestamps conversion problems
- ...

Have thoses changes to be done staying compatible with PostgreSQL and
if not will the Editor maintain the new code ?

Regards
PAscal