Hello all, I can't seem to issue valid SQL statements with SQL Studio (DB 7.3.0.21) in general. I don't know if I'm missing something but as the TEST User I created some tables via CatalogManager->New->Table which are now listed under Tables->TEST->Table1 etc.
Now, many valid SQL statements like "SELECT * FROM TEST.Table1" or "SELECT * FROM Table1" (when connected as the TEST user) fail in the "Direct SQL" window with Negative Error No.: -4004 Error Text: Base table not found;-4004 POS(15) Unknown table name:TABLE1. Return code: -1 SQL State: [ODBC] [S0002] Base table not found Is there anything "obvious" I'm missing here? I'm asking since statements like "SHOW VERSION" in fact do work. Might it be related to the fact that I'm operating in SQL Mode: Internal? How do I change that? Thanks in advance, Philipp Robbel "Stausberg, Markus" <[EMAIL PROTECTED]> wrote: > Hello Philipp, > > sorry for answering late ... > you wrote : > > so I can't define ref. integrities to a foreign table's > > primary key (in > > sql studio)? > > true; if you try to define them with a database kernel version >= 7.3.0.21 > SQL Studio shows you only the explicitly defined Indexes as suggestions. > This is a bug (and will be fixed). > The workaround is to enter an appropriate SQL statement instead. > > > > I tried to additionally set the primary key to be an index > > but SQL Studio > > told me it already was one. > > after we pointed out that a primary key is _never_ an index > this error text is a bit misleading . It should tell that > "it is not possible to define an index on a primary key". > > > > regards, > > Markus Stausberg > SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
