Question and Answer Database FAQ3036D.txt — Delphi/400 : Queries against *LIBL Category :AS400 Platform :All-32Bit Product :DelphiAS400, Question: Trying to execute a sql query on an alias with property Libaryname set to "*LIBL" doesn't work. Example : MyTable is in MyLib Library and MyLib is included in *LIBL Select * from MyTable. returns "invalid expresion" exception. Answer: Set explicitly the libraryname in your statement : select * from MyLib/MyTable. 4/1/99 3:37:33 PM
Last Modified: 01-SEP-99