[Web-erp-users] Using alternative Databases

[Phil D. <ph...@du...>]

There is no problem using alternative databases. The SQL script may need
some modifications I have not tried it. Certainly references to table types
etc are peculiar to MySQL whether this would cause an issue with Firebird I
am not sure - maybe it would just be ignored.

Of course you would need to modify the database specific functions which are
all included in the file ConnectDB.inc from the MySQL ones to the Firebird
ones. This is the only file you would need to modify.

The only issue I think you might encounter in editing this file is with the
function

function DB_Last_Insert_ID(&$Conn){
return mysql_insert_id($Conn);

}

I am not sure but I think this function may be specific to mysql and may
need a little thought in how to get the id of the last record inserted
returned set up in different databases.

Once you have modified the ConnectDB.inc and the SQL script to work with the
Firebird database it would be nice to include these with the distribution
for other users. Similarly with any modifications to the table structure, I
am keen to incorporate any improvements in the system for all users.

It is fine to modify the table structure, but of course this can have nasty
results where the field is required elsewhere. If you have a specific
modification in mind I may be able to identify any potential issues you may
have.

Phil Daintree