topic Re: Validations selection screen. in Application Development and Automation Discussions

Validations selection screen.

Former Member — Mon, 30 Jun 2008 02:34:40 GMT

Hi Experts,

In my screen validations . when to use select single and when to use select upto 1 row. and the diffrence.

i hav done the selection screen validations ... now the problem is if the value entered is wrong also the output screen is coming... where if the user is entering wrong value.. it should come back to the selection screen.. not the output screen..

help me in this.

Regards,

Sunita.

Re: Validations selection screen.

Former Member — Mon, 30 Jun 2008 02:55:43 GMT

Hi Sunita,

Select single gives the first line of selection and select upto 1 row will read all result of a selection and gives you last entry.

For selection-screen validations you need to use At-Selection screen event, under that write your query using select single as it is the best option in validations ( increases performance ) as it will check the entry for existence.And the error message will stay in the same screen and will not go for output screen.

Thanks,

Ravi Kalapur

Re: Validations selection screen.

JoffyJohn — Mon, 30 Jun 2008 03:26:43 GMT

Use event

AT SELECTION-SCREEN OUTPUT.

do the select and checking here and raise the message then

START-OF-SELECTION.