I'm currently learning this new application call XOJO and trying to write a blob to the sqlite database on the valentina server, but I'm getting an error for unknown. If the sqlite is not in the valentina server it writes perfectly fine.
Here is the code I'm using.
Var row As New DatabaseRow
row.Column("ID".IntegerValue = Val(IDField.Text)
row.Column("Name".StringValue = NameField.Text
row.Column("Pic".BlobValue = PictureCanvas.Backdrop.ToData(Picture.Formats.PNG)
when I execute a button to run this code it will get stuck at the AddRow with unknown error. If I remove the Blob and run the code it will save it perfectly fine into the table. I tried following the valentina document for the blob write, but it gives me a bunch of error (unless I'm putting it in the wrong area).
If I do not want to save it as a blob how do I save the file directory onto the server? (Assumption: text field that once open will show picture onto the canvas with the directory on the text field. Text field will be saved onto the database)
Is there a special way to read the blob or file directory from the valentina server?
This is a new learning curve for me with programming and writing language. I do understand some of the basic concepts and know how to use the sqlite code from XOJO, but once connected to the valentina server some sqlite codes doesn't work like the blob and needs a vsqlite code instead.