MySQL Forums :: C#, Mono, .Net :: Create bool/tinyint(1) in Select of Procedure for DataViewCheckboxColumn in C#!?

Hello

I need to generated a column as bool / tinyint(1) in a select,
so the column will be displayed in my datagrid as checkbox.

I manage not to generate such a data type.
Is there a solution?

As an example:

CREATE PROCEDURE `myTest`()
BEGIN

Select
PK, FK .....
(case when PK_xyz is null then 1 else 0 end) as IsNew, -- Here bool / tinyint(1) needed
from TableXy
left join xyz ....
;
END


I have try different variants with Cast, Convert, bit ... but not brought the desired success.

Is there a solution to the problem?

Thank you an greetings
Christian



Edited 1 time(s). Last edit at 10/05/2012 12:59AM by Christian Leder.