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
