Skip to Content
avatar image
Former Member

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é

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 01, 2015 at 09:20 AM

    Can you display the image in a procedure of the following doc?

    http://dcx.sap.com/1201/en/dbadmin/isql-view-images.html

    If the image isn't displayed correctly, the insertion of the image was failed.

    Regards,

    Koichi

    Add comment
    10|10000 characters needed characters exceeded