2006 Dec 13 10:22 AM
Hi gurus,
can any one explain me about this code please
IF rsallowedchar-allowchar IS INITIAL.
SELECT SINGLE
allowchar
INTO (rsallowedchar-allowchar)
FROM rsallowedchar
WHERE allowkey = 'S'.
ENDIF.
regards
raju
Hi gurus,
can any one explain me about this code please
IF rsallowedchar-allowchar IS INITIAL.
SELECT SINGLE
allowchar
INTO (rsallowedchar-allowchar)
FROM rsallowedchar
WHERE allowkey = 'S'.
ENDIF.
regards
raju
2006 Dec 13 10:24 AM
this check if the field rsallowedchar-allowchar is empty
before it does the select
if it is empty it selects from table rsallowedchar the first value it finds
into field rsallowedchar-allowchar
where the field allowkey in table rsallowedchar is equal to S
2006 Dec 13 10:26 AM
IF rsallowedchar-allowchar IS INITIAL.
if the above condition is true it wil get the single record from rsallowedchar
into rsallowedchar-allowchar where the condition allowkey = 's'.
SELECT SINGLE
allowchar
INTO (rsallowedchar-allowchar)
FROM rsallowedchar
WHERE allowkey = 'S'.
ENDIF.
2006 Dec 13 10:34 AM
Hi Venkata Raju
If field allowchar is initial and field allowkey is equal to 's' then
a single record is fetched from Table rsallowedchar and inserted into
field allowchar.
bye -
Naresh-
2006 Dec 13 10:41 AM
'rsallowedchar' is a table. 'allowchar' is a field in the structure rsallowedchar.
IF rsallowedchar-allowchar IS INITIAL.
this line does a check whether the field allowchar is empty or not. If it is empty then a selection is made from the table reading one row of records matching the condition when allowkey is 'S'.
Hope this gave a clear explanation.