06-30-2008 3:34 AM
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.
06-30-2008 3:55 AM
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
06-30-2008 3:55 AM
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
06-30-2008 4:26 AM
Use event
AT SELECTION-SCREEN OUTPUT.
do the select and checking here and raise the message then
START-OF-SELECTION.