Radicore Forum: RADICORE Installation Issues

Home » RADICORE » RADICORE Installation Issues » Firebird support

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Firebird support [message #787 is a reply to message #786]

Wed, 25 April 2007 04:57

AJM
Messages: 2382
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.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]

		Firebird support By: ptimmermans on Wed, 25 April 2007 03:02
		Re: Firebird support By: AJM on Wed, 25 April 2007 04:57
		Re: Firebird support By: ptimmermans on Fri, 27 April 2007 06:29
		Re: Firebird support By: AJM on Fri, 27 April 2007 10:06
		Re: Firebird support By: ptimmermans on Tue, 01 May 2007 06:03
		Re: Firebird support By: AJM on Wed, 02 May 2007 06:04
		Re: Firebird support By: zamolxes on Wed, 25 July 2007 16:57
		Re: Firebird support By: AJM on Wed, 25 July 2007 18:28
		Re: Firebird support By: zamolxes on Wed, 25 July 2007 19:05
		Re: Firebird support By: AJM on Thu, 26 July 2007 05:05
		Re: Firebird support By: zamolxes on Thu, 26 July 2007 05:42

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Jul 09 14:07:39 EDT 2025

Total time taken to generate the page: 0.01322 seconds