Returns the specified message property as a SQL FLOAT data type.

Parameters

Return value

The property value as FLOAT.

Remarks

If the message property value is out of range, then a SQL error with SQLSTATE 22003 occurs.

You can read this property after a message is received and until a rollback or commit occurs; after that you cannot read it.

See also

• Setting up SQL applications
• ml_qa_setfloatproperty
• ml_qa_createmessage
• ml_qa_getmessage
• Custom message properties

Example

In the following example, a message is received and the value of float property myfloatproperty is output to the database server messages window:

begin
    declare @msgid varchar(128);
    declare @prop float;
    set @msgid = ml_qa_getmessage( 'myaddress' );
    set @prop = ml_qa_getfloatproperty( @msgid, 'myfloatproperty' );
    message 'message property myfloatproperty is set to ' || @prop;
    commit;
end