Anyone knows why you cannot return messages to the GUI panel using a cursor? I have a procedure that processes stock counts, and when there is an issue these are determined and returned as messages to the GUI panel using a cursor.
The problem is I see the warnings in the debug screen but not the actual panel in de the GUI. Bug?
Page 1 / 1
As far I know it's possible to use cursors with a tsf_send_message in it wrapped and sending it to a panel. I assume probably is wrong with your cursor code then. Please note that if there's an abort (1) given, it code might stop executing.
The code below should call 3 time tsf_send_message.
declare @tab table (id int identity primary key, name varchar(100)) insert into @tab (name) values ('Hello') insert into @tab (name) values ('ABC') insert into @tab (name) values ('XYZ')
declare cur_test cursor local forward_only read_only for select t.name from @tab t
Quick update: The cause has been identified. When the variables in the translation of the message are 1-based instead of 0-based, the messages will be suppressed by the GUI.
For instance, when the translation is as following, the message will be suppressed:
The translation must be as following to work correctly:
Having the GUI suppressing these faulty messages makes the problem difficult to identify and resolve for a developer.
A ticket will be submitted to have the GUI still show these messages partially- or unformatted, so the developer can fix the message translation accordingly.