[geek123]

Hello all,

I am working on SQR (Structured Query Reporting) language. I develop SQR programs. I need something like a vbscript or any other script that will write debug statements automatically to the sqr program.
I need debug statements for the begin-select,begin-sqr code blocks.
For example, for begin-select statements I need something like this :-

begin-select
emplid
name
city
from personaltable
where emplid='xyz'

For the above code debug statements can be like #debugs show ' emplid is' emplid. In the silimar way for all the other selected fields it should write this debug statement with the switch 's' ie; #debugs. For inserts and updates it would be like #debugi and #debugu respectively. So for the fields which are being selected,updated or inserted the debug statements should be written automatically before the begin-select and begin-sql blocks. i.e;

#debugs show 'emplid' $emplid
#debugs show 'name' $name

begin-select
emplid
name
from personaltable
where emplid='xyz'

Can anyone please help me in writing these debug statements automatically to the program by identifying those begin-sql and begin-select blocks using some kind of scripting language like a vbscript or using the SQR itself.

Thanks a lot in advance.

[geek123]

Please help me regarding this.