Re: adding data with isql

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