i have the ms sql column data type set to varbinary(max)
The value is set correctly
Whenever i delete the signature component my form works correctly, However anytime i add the signature component my edit crud page is no longer able to save the info? Any ideas?
{error: {code: "", message: "The input was not valid.",…}}
error: {code: "", message: "The input was not valid.",…}
1. code: ""
2. details: [{code: "", message: "The input was not valid."}]
1. 0: {code: "", message: "The input was not valid."}
3. message: "The input was not valid."
The Signature component needs a String property. Probably OData cannot convert that later to varbinary. You can try using a separate string property to store the signature and then convert it to the one used to persist it (check here how to extend the OData controllers). Alternatively change the DB type of your column to varchar(max) and infer the data source again.
Thank you, that allowed it to save the data. (I ended up changing the column type)
2 smaller issues now.
Whenever you go to reopen it, it duplicates the signature side creating a shadow effect
Top one is example of opening twice, and bottom one is an example of opening once, after first save,
How would I go about showing the signature in an ssrs report?
Okay for my second question what i did to make it work in SSRS is
Select CAST('' AS XML).value('xs:base64Binary(sql:column("[JoinColumnName]"))'
, 'VARBINARY(MAX)') AS SignatureImage
From TableName A
Left Join (Select ID, Right([YourColumnName],Len([YourColumnName]) -22) as JoinColumnName FROM [TableName ]) as A on A.ID = B.ID