Subject Spaces in Fields / Modifying
Author pnewmantripoint
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