Can't set a boolean field value using binds and the true keyword Description

[Erne]

Hello list,

I just reported this issue and maybe posting it here could prevent  
somebody else from falling in the same pit.

Summary
0001470: Can't set a boolean field value using binds and the true  
keyword

Description
In a SQL command using binds we can't use the True-False keywords to  
set the value of a Boolean field.
0-1 must be used instead.

Steps To Reproduce
Having a Table T1 with fld_string, fld_long, fld_bool fields, try  
this SqlExecute:

inQuery = "insert into T1 ( fld_string, fld_long, fld_bool ) values( : 
1, :2, :3 )"

arrBind(0) = "fixed string"
arrBind(1) = "125"
arrBind(2) = "true"

call mDatabase.SqlExecute( inQuery, arrBind )

the fld_bool will not be set to True




Cool Runnings,
Erne.

/ |\ |\  | /
– |/ | \ | –
\ |\ |  \| \