[Laurinda Chi]

Hello,

I am using a qSIListForm to display item from SQL data source, and I’m trying to match the update parameters in the stored procedure.  On the UI form, there are several check boxes which should be recognized as binary 0/1 (which I defined as tinyint data type in the SQL stored procedure).  However, when I clicked the Execute (Update) button, I’m getting the following error:

An error occurred while connecting to database: Failed to convert parameter value from a String to a Byte.

 

Could you please advise?  Any suggestions will be appreciated.

Thanks in advance for your help!

Laurinda Chi

[Rachit Vyas]

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

[Laurinda Chi]

Hi Rachit,

Thank you!  After I changed the SQL data type to bit for these checkbox fields in my SQL stored procedure, it’s now working properly on the qSIListForm when performing an update action.

Thanks for your help with this!

Best regards,

Laurinda Chi

[Author]

Posts