Subject Re: [firebird-php] FireBird/ADODB
Author Lester Caine
Alan McDonald wrote:
>> Alan McDonald wrote:
>>>>> Now for the generators!
>>>> try that on the datadict-firebird and see if it builds the triggers :)
>>>>
>>> got them all ok now
>> Can you copy me back your changes :)
>> It would be nice to get it working here as well ;)

> you're more familiar with ADODB...
> where would a query such as
> SELECT pref_name, pref_value FROM {prefs} ...
> get transformed into
> SELECT pref_name, pref_value FROM "FS_prefs" ...
>
> ad how do I (if there's away) turn off the double quoted object names?

Sorry been tied up

DEFAULT should be NULL for Firebird ( and Oracle )

The prefix will be added by flyspray

$nameQuote = '';
Should switch off the double quotes. I'm suprised it's not off, so flyspray
may actually be switching it ON.
I noble NameQuote() in the firebird driver to prevent them being added.

bw runs totally without double quoting ;)

--
Lester Caine - G8HFL
-----------------------------
Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://home.lsces.co.uk
MEDW - http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Firebird Foundation Inc. - http://www.firebirdsql.org/index.php