Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » QAnywhere » QAnywhere API Reference » QAnywhere SQL API reference » Message properties, headers, and content » Message properties

 

ml_qa_setbooleanproperty

Sets the specified message property from a SQL BIT data type.

Parameters
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 BIT
Remarks

You cannot alter this property after the message has been sent.

See also
Example

In the following example, a message is created, the boolean properties mybooleanproperty1 and mybooleanproperty2 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_setbooleanproperty( @msgid, 'mybooleanproperty1', 0 );
    call ml_qa_setbooleanproperty( @msgid, 'mybooleanproperty2', 1 );
    call ml_qa_putmessage( @msgid, 'clientid\queuename' );
    commit;
end