Subject | IB_Import and reserved words |
---|---|
Author | ashwiz_za |
Post date | 2005-12-09T19:16:06Z |
Hi there
I am using IB_Import, but am having trouble as of the columns names are
reserved words.
Now, normally I simply quote them and IB-Objects understands them
fine, but
with IB_Import
doesn't seem to work?
Eg: CODE VARCHAR(5) NOT NULL,
DESCRIPTION VARCHAR(15),
"DEFAULT" CHAR(1),
I am including the column names in the first line of the text file to
import, and
have tried using quotes there, but still same problem...
--
Any ideas will be much appreciated!
Thanx in advance!!!
Many thanx
Kind regards
Ashley
~~~~~~~~~~~~~~~~
The Software Shack cc
www.softwareshack.co.za
I am using IB_Import, but am having trouble as of the columns names are
reserved words.
Now, normally I simply quote them and IB-Objects understands them
fine, but
with IB_Import
doesn't seem to work?
Eg: CODE VARCHAR(5) NOT NULL,
DESCRIPTION VARCHAR(15),
"DEFAULT" CHAR(1),
I am including the column names in the first line of the text file to
import, and
have tried using quotes there, but still same problem...
--
Any ideas will be much appreciated!
Thanx in advance!!!
Many thanx
Kind regards
Ashley
~~~~~~~~~~~~~~~~
The Software Shack cc
www.softwareshack.co.za