Loading...

Reply To: qSIListForm – how to convert checkbox (Y/N) to SQL tinyint (1/0) data type?

Reply To: qSIListForm – how to convert checkbox (Y/N) to SQL tinyint (1/0) data type?

Home Forums QuickApps Forum qSIListForm – how to convert checkbox (Y/N) to SQL tinyint (1/0) data type? Reply To: qSIListForm – how to convert checkbox (Y/N) to SQL tinyint (1/0) data type?

#10298
Rachit Vyas
Rachit Vyas
Participant

Hi Laurinda,
As you are using tiny int in the SQL stored procedure and check boxes recognized as binary 0/1. So you want to update the parameters in the SP. It will give an error, You can try Bit(you can’t change datatype by SiWebPart) as data type in sql SP. Hope it  helps you.
In case you need any further help or want to discuss the same , please feel free to log a case with our support team of QuickApps

Thanks