Should work, you might re-check permissions on the view to include the SQR login user. I am not familiar with Maximo however. Regards, Brent btempleton@pmai.org -----Original Message----- From: Ward, Martin [SMTP:martin.ward@IT.NEWSINT.CO.UK] Sent: Friday, January 24, 1997 8:52 AM To: Multiple recipients of list SQR-USERS Subject: 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
Unrecognized Data: application/ms-tnef