MySQL Forums :: C#, Mono, .Net :: Create bool/tinyint(1) in Select of Procedure for DataViewCheckboxColumn in C#!?
Create bool/tinyint(1) in Select of Procedure for DataViewCheckboxColumn in C#!?
Date: October 05, 2012 12:56AM
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`()
PK, FK .....
(case when PK_xyz is null then 1 else 0 end) as IsNew, -- Here bool / tinyint(1) needed
left join xyz ....
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
Edited 1 time(s). Last edit at 10/05/2012 12:59AM by Christian Leder.
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.