>Hi,
>
>This is the problem. Converted number with STR(12.2,10,2) is 12,2 and SQLEXEC gets string
>
>SQLEXEC(handle," Update Mytable SET num=11,2 ... " This generates an error incorect syntax near 2

Why do you do such conversion :

lnNumber = 12.2
SQLEXEC(handle," Update Mytable SET num=?lnNumber ... "

Cetin