Subject | RE: [IBDI] Delphi, IBX, DDL (repost) |
---|---|
Author | Ungod |
Post date | 2000-06-21T08:46:27Z |
"my" workaround, is using "quotes" around field/table names everywhere and
dialect 3 of course. don't know if this helps.... (it allowed me to
successfully use Key as a field name)
--
Ungod (W.King)
www.bytamin-c.com
www.magick.tm
I found the answer, now where'd I put that problem...
-----Original Message-----
From: Carl J. Mosca [mailto:cmosca@...]
Sent: Wednesday, 21 June 2000 6:10 AM
To: IBDI@egroups.com
Subject: [IBDI] Delphi, IBX, DDL (repost)
Last week I explained (and probably not very well I might add) a problem I
was having with my "dbConvert" app.
It generates SQL (DDL) from any (BDE) table and then executes it against an
InterBase 6 database. (This is the tool I'd like to finish up and release
as freeware but it's got a ways to go.)
Anyhow I bumped into a field name that happens to be a keyword (in this case
"End"). If I copy the generated SQL from my app, it works fine when I use
IBConsole. (The keyword is quoted in the generated SQL.) I thought
(incorrectly) that I did not have the latest IBX stuff.
Just thought I ask again in case anyone can shed some light on this. I can
do it manually but my app copies the data too and this slows things down a
bit.
Carl
------------------------------------------------------------------------
Failed tests, classes skipped, forgotten locker combinations.
Remember the good 'ol days
http://click.egroups.com/1/5531/4/_/679568/_/961531610/
------------------------------------------------------------------------
Community email addresses:
Post message: IBDI@onelist.com
Subscribe: IBDI-subscribe@onelist.com
Unsubscribe: IBDI-unsubscribe@onelist.com
List owner: IBDI-owner@onelist.com
Shortcut URL to this page:
http://www.onelist.com/community/IBDI
dialect 3 of course. don't know if this helps.... (it allowed me to
successfully use Key as a field name)
--
Ungod (W.King)
www.bytamin-c.com
www.magick.tm
I found the answer, now where'd I put that problem...
-----Original Message-----
From: Carl J. Mosca [mailto:cmosca@...]
Sent: Wednesday, 21 June 2000 6:10 AM
To: IBDI@egroups.com
Subject: [IBDI] Delphi, IBX, DDL (repost)
Last week I explained (and probably not very well I might add) a problem I
was having with my "dbConvert" app.
It generates SQL (DDL) from any (BDE) table and then executes it against an
InterBase 6 database. (This is the tool I'd like to finish up and release
as freeware but it's got a ways to go.)
Anyhow I bumped into a field name that happens to be a keyword (in this case
"End"). If I copy the generated SQL from my app, it works fine when I use
IBConsole. (The keyword is quoted in the generated SQL.) I thought
(incorrectly) that I did not have the latest IBX stuff.
Just thought I ask again in case anyone can shed some light on this. I can
do it manually but my app copies the data too and this slows things down a
bit.
Carl
------------------------------------------------------------------------
Failed tests, classes skipped, forgotten locker combinations.
Remember the good 'ol days
http://click.egroups.com/1/5531/4/_/679568/_/961531610/
------------------------------------------------------------------------
Community email addresses:
Post message: IBDI@onelist.com
Subscribe: IBDI-subscribe@onelist.com
Unsubscribe: IBDI-unsubscribe@onelist.com
List owner: IBDI-owner@onelist.com
Shortcut URL to this page:
http://www.onelist.com/community/IBDI