Re: Problems with DSA 7.12

As Ian Goddard commented: }From: Ian Goddard <igoddard@netcomuk.co.uk> }Date: Tue, 03 Sep 1996 00:59:46 -0700 }X-Informix-List-Id: <news.27676> } }Paul Jones wrote: }>[...] }What version of SQL did you use to build the screen form? If it was 6.03 } perhaps 7.11 ESQL/C isn't compatible with it. You should be compiling any ESQL/C built into the custom Perform with the 6.00 ESQL/C compiler. Since you don't have that installed, but you do have the 6.03 I4GL c-code system, compile the ESQL/C code with the c4gl script, and then link with the 6.03 cperf script. Mixing c-code generated by the 7.11 ESQL/C compiler with the 6.0x ESQL/C included in the ISQL product is prone to disaster. Whether it does account for the problem is another matter -- it is odd enough that it could, but not a foregone conclusion. Nevertheless, a rigid separation of the ESQL/C versions is necessary. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> }Date: Mon, 2 Sep 1996 17:57:01 -0400 (EDT) }From: Paul Jones <pjones@btl.net> }X-Informix-List-Id: <list.11224> } }We are currently running Informix Online 4.1 on a Unysis System which we }have outgrown. We are in the process of upgrading to Informix DSA on a Sun }ES4000 but have encountered the following problems / situations. } }1. If we make an entry into the database using a regular 'sperform' }screen, any date entered is displayed differently when the same record is }queried using the same form run with a 'cperf' program. This problem occurs }in both directions. } eg. "02/09/1996" was entered in a date field using a form run by a }'cperf' program } This date was displayed as "02/03/1996" when queried using the }same screen run with 'sperform' } } "03/09/1996" was entered in a date field using a screen run with }'sperform' } This date was displayed as "65/13/1996" when queried using the same }screen run with 'cperf' } (Note: we use the "ddmmyy" format) } }We know the problem is not with the form file since we used the same form }file for entering and viewing the record. The only thing that changed was }the method or running it: 'sperform' vs. a 'cperf' program. } }2. ESQL/C and 4GL programs compiled under DSA are at least twice the }the size of those compiled under our older versions of informix } }The specifications for the new system is as follows: }Operating system: Solaris 2.5 Release 5.5.1 }Hardware: Sun ES4000 }Informix Software } ESQL/C 7.11 UC2 } SQL 6.03 UC1 } Online 7.12 UC2 } 4GL 6.03 UD1 } }I would really appreciate some help on the two abovementioned issues. I }suspect there is a compatibility problem with problem 1. Can anyone shed }some light??