This sounds like the same issue that was answered in the thread "IBO bug:
parameters ouside where clause produce" five days ago, where heLen gave a
better answer than I can aspire to do.

HTH,
Set

At 06:39 23.07.2003 +0000, you wrote:

>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