Query Designer

rbuser

Hi,

I need to filter the on a Boolean field in the search criteria page, but I
can't seem to be able to set the value as it keeps coming up with errors
saying 'Invalid Column Name: 'TRUE'', 'Error in expression: TRUE'.

What is a valid value, as I can't find anything in the documents?

Thanks In Advance
Martin

nicocizik

Hi Martin,

Which database are you using? Check you data settings in the main menu of
the data tab and be sure you have the correct DB and SQL type defined. Some
databases such as SQLServer do not use True and False for boolean values.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com