[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

SQR/SQR3 Querying on Database Views



Can SQR/SQR3 'select' from a database view?.

My version(s) of SQR come bundled with the MAXIMO Maintenance Management
Package. I have tried to select from a view that I have created at the
database level, but I receive a 'TABLE not CREATED' SQR Error.

Interestingly, the MAXIMO Application has views on its tables, and SQR
can select from them. I am not sure whether the catalog that the SQR
sees is purely linked to the MAXIMO application.

For information I am running a SQLBase database.

Many thanks for any help.
Regards
M.J.Ward
MAXIMO Analyst
Systems Development
News International Newspapers Ltd.
email : martin.ward@it.newsint.co
Tel:  0171-782-6389
fax: 0171-782-6416