Re: PLEASE PLEASE PLEASE Help Me!!!

Keith, It sounds to me as if your third party product is very strange. I have seen problems with TETRA, which uses NULL terminated character strings rather than fixed length ones as INFORMIX does. I have never encountered any product which needs 24 characters to indicate a record lock. Also, Beware the word NULL!!!! In 'C' a null string is a single character containing the hex value x'00' . In INFORMIX a NULL string would not be equal to X'00' and a NULL Numeric field is not equal to zero. INFORMIX uses special codes for NULL character fields and NULL numerics. In INFORMIX - NULL is not equal to NULL and NULL is not NOT EQUAL to NULL. Malcolm Weallans OnLIne Database Consultancy (+44)628-72154 Fax (+44)628-37463