Hi, The Catalogview of SQL Studio needs a certain column in the "Tables" Table. If the select statement to check for this column fails you get mentioned error. Please execute this sql statement in a sql dialog window.
SELECT TABLETYPE FROM DOMAIN.TABLES WHERE TABLENAME = 'TABLES' If it fails you should check if your systemtables are ok. regards Wolfgang -----Original Message----- From: Scott Mackenzie [mailto:samackenzie@;shaw.ca] Sent: Sonntag, 3. November 2002 07:45 To: [EMAIL PROTECTED] Subject: SQL Studio - Catalog View I'm a new user of SAP DB and I'm running into trouble with SQL Studio Catalog View. I've downloaded and installed SAP DB 7.3.00 for windows NT/2000 and I'm running it on Win XP. I can connect with SQL studio to my test database however I get an error message from Catalog Manager saying "SQL Studio does not support the catalog view when connected to databases prior to 7.3.0". Database Manager tells me that the version of my test database is 7.3.0.25. In SQL Studio I can use SQL dialog to create and query tables but the Catalog Manager menu, Visual Query and Form Dialog don't seem to be working properly. Any Idea's as to what could be wrong? It would be nice to have a visual representation of my tables and relationships. _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
