You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Alias Name in %Selectall

1 reply [Last post]
Guest's picture

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);

Lepa's picture
User offline. Last seen 2 years 26 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Alias Name in %Selectall

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