Subject | Spaces in Fields / Modifying |
---|---|
Author | pnewmantripoint |
Post date | 2003-07-23T06:39:43Z |
Hi,
I am using a delphi component suit called KBMMW (Great N-Tier
product !!) in
ascociation with IBOBjects. I am using Firebird 1.5. I have a simple
test
table ...
TEST_TABLE
FLD1 Varchar 10 PK
FLD 2 Varchar 20
when I modify FLD 2 in a record KBMMW generates the following SQL
statement.
UPDATE TEST_TABLE SET "FLD 2"=:"FLD 2" WHERE FLD1=:KBMMW_KEY_FLD1
KBMMW then passes this to IBO and tells it to prepare it. This is
where
things get strange ... IBO creates a parameter named
'FLDWHERE TEST_TABLE."FLD1"=?/*KBMMW_KEY_FLD1*/
I think it should be "FLD 2".
Is it possible to have a space in the parameter name of the SQL
statement
the way KBMMW generates it ?
UPDATE TEST_TABLE SET "FLD 2"=:"FLD 2" WHERE FLD1=:KBMMW_KEY_FLD1
Please help ...
Thanx
Paul Newman
I am using a delphi component suit called KBMMW (Great N-Tier
product !!) in
ascociation with IBOBjects. I am using Firebird 1.5. I have a simple
test
table ...
TEST_TABLE
FLD1 Varchar 10 PK
FLD 2 Varchar 20
when I modify FLD 2 in a record KBMMW generates the following SQL
statement.
UPDATE TEST_TABLE SET "FLD 2"=:"FLD 2" WHERE FLD1=:KBMMW_KEY_FLD1
KBMMW then passes this to IBO and tells it to prepare it. This is
where
things get strange ... IBO creates a parameter named
'FLDWHERE TEST_TABLE."FLD1"=?/*KBMMW_KEY_FLD1*/
I think it should be "FLD 2".
Is it possible to have a space in the parameter name of the SQL
statement
the way KBMMW generates it ?
UPDATE TEST_TABLE SET "FLD 2"=:"FLD 2" WHERE FLD1=:KBMMW_KEY_FLD1
Please help ...
Thanx
Paul Newman