Subject | "Quoted" TABLES |
---|---|
Author | Lester Caine |
Post date | 2004-08-18T14:00:31Z |
I've just had to dig out an old package of software which runs on FB1
and IBO3. I've converted to IBO4, but thought I would switch to FB1.5 as
well.
The problem of cause is new reserved words - in this case a table and
fields called RELEASE. I've added quotes to the names in the script, and
built an .fdb blank, pumped the data in via IB_SQL, and have everything
ready to go, except TIBOTable does not seem to like quoted table names.
Is this a known niggle that is fixed in a later version ( I'm still sat
on a year old 4.2 version for various reasons ) or am I just getting
something wrong.
Changing the name is probably not a problem, but adding the quotes was
supposed to work ;)
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
and IBO3. I've converted to IBO4, but thought I would switch to FB1.5 as
well.
The problem of cause is new reserved words - in this case a table and
fields called RELEASE. I've added quotes to the names in the script, and
built an .fdb blank, pumped the data in via IB_SQL, and have everything
ready to go, except TIBOTable does not seem to like quoted table names.
Is this a known niggle that is fixed in a later version ( I'm still sat
on a year old 4.2 version for various reasons ) or am I just getting
something wrong.
Changing the name is probably not a problem, but adding the quotes was
supposed to work ;)
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services