Re: adding data with isql

Hello Jonathan! Hello list! Your german colleague told me that in version SQL 7.30.UC1 is a bug. I try to get version 7.30.UC2 as fast as possible. Thank you for your wise tips! Take care. Dirk Emmermacher PS to Jonathan: Visit me under: http://www.mikromodell.de ! Dirk Emmermacher wrote: > > Hello Joanthan! > > Jonathan Leffler wrote: > > > > On Thu, 10 Aug 2000, Dirk Emmermacher wrote: > > >For additional information: I use following products on a HP-UX 10.20 > > >server: > > >SQL (developer) 7.30.UC1 > > >SQL (runtime) 7.20.UE1 > > >RDS (dev. & runtime) 7.20.UE1 > > >IDS 7.30.UE1 [** amended to 7.30.UC8 in a second message **] > > >Client SDK 2.20.UC1 > > > > > >Can it be the combination of the productversions that give this error. > > > > Yes. The 7.20 runtime should be upgraded to 7.30, or you should develop > > with a 7.20 development system instead of using the 7.30 system. > > > > >My users get an new problem: Some permissions on tables don't work. All > > >permissions are given to the user but when he starts the form only a > > >message appears "No select permission". It would be a good idea to add > > >the information which table deny a select! > > > > > >Jonathan Leffler wrote: > > >> Dirk Emmermacher wrote: > > >> > After changing from 4.00.UH2 (SE) to IDS 7.30.UE1 and upgrade isql to > > >> > 7.30.UC1 I got a problem inserting data. > > >> > The recompiled form don't insert data into a table with a serial field. > > >> > Error message: Cannot insert null value in tabname.fieldname. The form > > >> > works on the old database without any problems. > > >> > > > >> > Any ideas what can be wrong? > > >> > > >> Sounds like it might be a bug. Since you compiled the forms again... > > > > It sounds less like a bug now that we know there are mismatched product > > versions in use. The developers presumably do test with the 7.30 system > > and don't run into the problem? So it is only the users using 7.20 who > > suffer? > > A form compiled with isql 7.30 don't run under isql 7.20. My user find > two other errors: > After adding rows the message "Row added" is shown. After query to this > record there is NO record. > Second error: Some forms use composites. In this forms you can't change > data because there are values that don't composites. (I believe I go mad > next time...) > > To the history: Last week my old server (near 10 years old) got mad. The > database (4.00.UH2 SE) has often I/O errors on the index files. I try to > repair the indexfiles. After a little panic by myself I transfer the > data in ascii-files to the other machine. I create a database and load > the data. > > Take care. > > Dirk Emmermacher