Will I be able to use an Alias name while using the Meta-SQL %Selectall
as shown below ?
&SQL1 = CreateSQL("%Selectall(:1 F) where F.FIELD1 <> ' ' and F.STATUS = 'A' and not exists (select 'X' from PS_RECORD1 A where A.EMPLID = F.EMPLID and A.EMPL_STATUS = 'A')", &Record2);
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
hmm, I never tried it before. I think it should work BUT you seem to be missing a ",". I was expecting your %Selectall(:1 F) to be %Selectall(:1 , F) (notice the comma i've added. Try that and let us know.
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog