Hello,
Would it be possible to transform some
Interbase/Firebird reserved words (on a setup basis),
into "RESERVED" words inside SQL statements ?
Example:
create table A (active varchar(10)) --> fails
create table A ("ACTIVE" varchar(10)) --> ok
select active from A --> fails
select "ACTIVE" from A --> ok
If anybody can provide me script example it would be great
Regards
PAscal
Logged In: NO
find below a proposal for the ACTIVE reserved word
function &_Execute($sql,$inputarr=false)
{
global $ADODB_COUNTRECS;
// added for Reserved Word
$sql = preg_replace(" /active/i ","
\"ACTIVE\" ",$sql);
// End of Reserved Word addition
Regards