On 24/01/16 08:04, Ertan Küçükoğlu [email protected] [firebird-support] wrote: > I needed some time to understand (at least try to understand) your post. > Please, note that my SQL knowledge is very limited. I really don’t know > internals of database any system. Though, I need to develop an application > which can use Firebird, Interbase, MSSQL, MySQL, Oracle. Some of users > databases may be Firebird, others MSSQL, and an Oracle maybe. User decides > what to use.
I currently develop projects using PHP which users access via a web browser. I've used a library called ADOdb since day one, and this massages a large section of the SQL into a format that can be used by any of the large number of databases it supports. It also has a meta data management tool that allows a generic table description to be used to provide metadata changes cross database. All one has to ensure is that field and table names are not reserved words across all the database engines that are being used. It may not be something you can use, but it will provide an insight as to how it can be done. -- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk
