Agentry Signature to SQLAnywhere
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?