Re: adding data with isql

Hello Jonathan! Thanks for your respond! 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 Client SDK 2.20.UC1 Can it be the combination of the productversions that give this error. 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! Best regards. Dirk Emmermacher 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... > > -- > 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!"