Re: adding data with isql

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? -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"