topic Re: Changing the Query in Application Development and Automation Discussions

Changing the Query

Former Member — Mon, 23 Feb 2009 08:59:51 GMT

Hello All,

I need to make authority check on Plant which is a select-options field of the existing Query.I went to SQ02 and tried to change the code in start-of-selection(tried in other events too).When I put break-point it is getting triggered, but when I use the screen field name of plant(SP$00008) in code query is throwing an error at the generation time saying "SP$00008 is not defined by DATA statement".

In short when I try to write the code in SQ02 I am unable to access the selection fields.Please suggest what to do?

Regards,

Shafivullah Mohammad

Re: Changing the Query

Former Member — Mon, 23 Feb 2009 09:02:54 GMT

Probably it may not be in Global declaration. Try keeping it in Global data

Re: Changing the Query

kiran_k8 — Mon, 23 Feb 2009 09:05:20 GMT

Shafi,

We can change the Query and the tables used in it,but we can even change the code generated by the query?I am not aware of this,looking forward to the replies.

K.Kiran.

Re: Changing the Query

Former Member — Mon, 23 Feb 2009 09:06:09 GMT

Hello Phani,

Thanks for ur advise but it is not the Global data it is a select-options field name.

Regards,

Shafivullah

Edited by: shafivullah mohammad on Feb 23, 2009 2:36 PM