Hi, you wrote : > 1.Insert/Update/Delete records in a Table which has data type > set as SERIAL using SQLStudio GUI is impossible. > Example: > > CREATE TABLE T1( > "C1" Integer DEFAULT SERIAL (1), > "C2" Integer ) > // > CREATE TABLE T2( > "C1" Integer DEFAULT 1, > "C2" Integer ) > > then using SQLStudio I created QBE(Query by example) > and pasted the table T1 in it. Then I could not edit any of > its records while if I paste T2 � there is no such problem. Why ?
This is a bug in SQL Studio. Thanks. It occurs because it is _not_ possible (by the db kernel) to update a row in "T1.C1", it _is_ possible to insert arbitrary records (overriding the default), and SQL Studio does not distinguish between the 'insert' and the 'update' cases. (worse, even with 'normal' default values you will find that sql studio explicitly 'NULL's "T2.C1" if you don't enter a value for it in QbE.) > 2.Problems creating table index using SQLStudio GUI when user > is in USERGROUP. > Example: > CREATE USERGROUP TESTGROUP RESOURCE NOT EXCLUSIVE > // > CREATE USER TEST PASSWORD TEST USERGROUP TESTGROUP > > then I logon using user: TEST and password: TEST, then > CREATE TABLE T1( > "C1" Integer, > "C2" Integer ) > > then, using SQLStudio GUI, I click over the table name with > the right mouse button and select �New | Index�. SQLStudio > GUI Index component appears, but it is unusable, because no > Table name is > specified in �on Table� field. How could I use it ? Another bug here ... thanks for reporting. (SQL Studio tries to construct the tablename to lookup in several system tables from the loginname and the name of the selected item in the catalogview , like "TEST.T1" which does not work here; in case of "TEST" belonging to group "TESTGROUP" the system catalog refers to that table as "TESTGROUP.T1") regards, Markus Stausberg SAP Labs Berlin > -----Original Message----- > From: sth [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 02, 2002 1:18 PM > To: [EMAIL PROTECTED] > Subject: Possible bugs in SAP SQLStudio > > > Hi, > we installed SAPDB and SQLStudio 7.4 for testing purposes. We > investigated the following possible bugs in SQLStudio: > > 1.Insert/Update/Delete records in a Table which has data type > set as SERIAL using SQLStudio GUI is impossible. > Example: > > CREATE TABLE T1( > "C1" Integer DEFAULT SERIAL (1), > "C2" Integer ) > // > CREATE TABLE T2( > "C1" Integer DEFAULT 1, > "C2" Integer ) > > then using SQLStudio I created QBE(Query by example) > and pasted the table T1 in it. Then I could not edit any of > its records while if I paste T2 � there is no such problem. Why ? > > 2.Problems creating table index using SQLStudio GUI when user > is in USERGROUP. > Example: > CREATE USERGROUP TESTGROUP RESOURCE NOT EXCLUSIVE > // > CREATE USER TEST PASSWORD TEST USERGROUP TESTGROUP > > then I logon using user: TEST and password: TEST, then > CREATE TABLE T1( > "C1" Integer, > "C2" Integer ) > > then, using SQLStudio GUI, I click over the table name with > the right mouse button and select �New | Index�. SQLStudio > GUI Index component appears, but it is unusable, because no > Table name is > specified in �on Table� field. How could I use it ? > > Best regards, > Stefan > > > > > _______________________________________________ > 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
