Главная страница | назад

Article #18036: Delphi/400 : Queries against *LIBL

 Question and Answer Database

FAQ3036D.txt - Delphi/400 : Queries against *LIBL

Category   :AS400
Platform   :All-32Bit
Product    :DelphiAS400,   

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.

Set explicitly the libraryname in your statement :

 select * from MyLib/MyTable.

4/1/99 3:37:33 PM

Last Modified: 01-SEP-99