-
Rafał Blecharz
- PowerServer
- Friday, 28 November 2025 08:24 AM UTC
Hello.
I'm using PS 2025 and it's really promising. Using Kestrel or remote IIS. The application works well, saving and reading data works without any problems. However, I'm having trouble read & writing BLOBs. Simple instructions
Blob Lblob
SELECTBLOB xml_varbinary into :Lblob from MY_TABLE_NAME where id_dok = :as_id_dok;
MS SQL Server:
Column: xml_varbinary -> varbinary(MAX)
return error:
fail: PowerServer.Api.ServerApiController[1003]
UpdateBlobWithParm(0HNHE9C9UCQ61:000000D8)(2025-11-28 06:57:24.9136729): get result (
{
"IsSuccess": false,
"AppName": "XXX",
"NameSpace": "XXX",
"Type": "ESQLUpdateBlob",
"SessionId": "BC744C2C-95D0-444D-9D83-AA08E14ADA25",
"TransactionId": "36A74C2B-7137-4EC2-B1ED-69273DCB6345-7",
"TransactionName": "sqlca",
"SqlId": "sqlHandle_06_EF1ED2C6",
"SqlStatement": null,
"Result": 0,
"ErrorCode": 156,
"ErrorMessage": "Incorrect syntax near the keyword 'from'."
})
BTW:
the instruction run via PB2025 works fine
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.