Example 5

This example illustrates working with properties:

select msgconsume('sub1')

declare @pcount integer
declare @curr integer
declare @pname varchar(100)
select @curr=1
select @pcount = msgpropcount()
while(@curr<=@pcount)
begin
      select @pname=msgpropname(@curr)
      select msgproptype(@pname)
      select msgpropvalue(@pname)
      select @curr=@curr+1
end

Copyright © 2004. Sybase Inc. All rights reserved.

View this book as PDF