Sets the specified message property from a SQL DOUBLE data type.
Item |
Description |
Remarks |
---|---|---|
1 |
Message ID |
VARCHAR(128). You can obtain the message ID from ml_qa_createmessage or ml_qa_getmessage. |
2 |
Property name |
VARCHAR(128) |
3 |
Property value |
DOUBLE |
You cannot alter this property after the message has been sent.
In the following example, a message is created, the double properties mydoubleproperty1 and mydoubleproperty2 are set, and the message is sent to the address clientid\queuename:
begin declare @msgid varchar(128); set @msgid = ml_qa_createmessage(); call ml_qa_setdoubleproperty( @msgid, 'mydoubleproperty1', -12.34e-56 ); call ml_qa_setdoubleproperty( @msgid, 'mydoubleproperty2', 12.34e56 ); call ml_qa_putmessage( @msgid, 'clientid\queuename' ); commit; end