Hi, > > > After some serious head banging I determined that a table > > > with a DEFAULT > > > SERIAL field will not allow you to add records in a Form > > > Dialog. Is there > > > a reason for this or is it a bug? If it is a bug, is there am > > > appropriate > > > place to file a bug report? > > > > > > This is an old bug which is fixed since SQL Studio version 7.4.3.17.
this was not true, a closer look showed that the bugfix has not gone into 7.4.3.17 . My apologies ... , and sorry for the inconvenience. The next release (it contains the fix) will be online in 2-3 weeks. regards, --- Markus Stausberg SAP Labs Berlin > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, July 14, 2003 5:28 PM > To: Stausberg, Markus > Subject: RE: SQL Studio - DEFAULT SERIAL and FK questions > > > Hi Markus, > > This is using 7.4.3.17. Read only mode is off. > If there is a later build than this, it's not available on > the web page. I > just re-downloaded SQLStudio and DBM and reinstalled to make > sure I had > the latest versions. SS is 7.4.3.17 and DBM is 7.4.3.10... > > This table definition will allow new records to be inserted > (insert,update,delete buttons active): > CREATE TABLE "SA"."DELME" ( > "ID" Integer NOT NULL, > "INFO" Char (5) ASCII, > PRIMARY KEY ("ID") > ) > > This table definition does not (insert,update,delete buttons > inactive): > CREATE TABLE "SA"."DELME2" ( > "ID" Integer NOT NULL DEFAULT SERIAL (1), > "INFO" Char (5) ASCII, > PRIMARY KEY ("ID") > ) > > Thank you for your help & take care, > > John > > > On Mon, 14 Jul 2003, Stausberg, Markus wrote: > > > Hello, > > > > > After some serious head banging I determined that a table > > > with a DEFAULT > > > SERIAL field will not allow you to add records in a Form > > > Dialog. Is there > > > a reason for this or is it a bug? If it is a bug, is there am > > > appropriate > > > place to file a bug report? > > > > > > This is an old bug which is fixed since SQL Studio version 7.4.3.17. > > > > If you already use a new version, make sure that the form dialog > > is not in read-only mode. If the problem persists, please send > > me the table definition and instructions to reproduce the behaviour. > > > > regards, > > > > --- > > > > Markus Stausberg > > SAP Labs Berlin > > > > > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
