Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE » RADICORE Installation Issues » Firebird support
Re: Firebird support [message #787 is a reply to message #786] Wed, 25 April 2007 04:57 Go to previous messageGo to previous message
AJM is currently offline  AJM
Messages: 2303
Registered: April 2006
Location: Surrey, UK
Senior Member
The first thing to need to do is to create a dml.firebird.class.inc file so that you can call the APIs which communicate with that DBMS. Leave interrogation of the INFORMATION_SCHEMA (used used by the data dictionary 'import' functions) till later.

The second step is to take the existing schemas for the MENU, AUDIT, WORKFLOW and DICTIONARY databases, modify them as necessary, then load them into firebird. You may also want to do this with the prototype subsystems as well.

The third step is to load all the data (from the xxx-data.sql files) into the relevant databases.

The fourth step is to change your CONFIG.INI file so that GLOBALS['dbms'] has the value 'firebird'. It is IMPORTANT that this value matces EXACTLY what appears between 'dml.' and '.classes' in the file you created with the first step.

Having done that you should be able to logon to radicore so that you can check that it handles all SELECTs, INSERTs, UPDATEs and DELETEs correctly. It does not matter that at this point you will be using <table>.dict.inc files which were created from a different DBMS.

When this has been done the last step is to modify the various ddl_???() methods in your new database driver so that the dictionary import functions will work.

If you have any more questions please let me know.


 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Error while creating menu database in 1.26
Next Topic: Problem with _cm_formatData in v1.27, Detail view
Goto Forum:
  


Current Time: Tue Jun 28 14:10:14 EDT 2022

Total time taken to generate the page: 0.01562 seconds