Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Agentry Signature to SQLAnywhere

Hi,

we use the SMP Server 3.0 SP 06 and The SMP SDK SP 06. We create a Transaction Step for a SQL Backend which should write the Signature bmp file to the SQLAnywhere databasetable.

INSERT INTO OrderSignature (OrderID, Signature, SignatureType) VALUES ('<<transaction.orderID>>', '<<transaction.signature.bmp>>', '<<transaction.signature.type>>')

After Transmit the AgentryServer writes the hexadecimal values into the Signature row and as type 'image' in the SignatureType row.

If we try to export the image blob with the sqlAnywhere command :

SELECT xp_write_file(OrderID||'.bmp, Signature) from OrderSignature;

we only get corrupdet bmp Files and we could not open one of it.

Do we anything wrong? How do you export the Signatures from the Client to a backend?

Thanx,

André

Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question