Re: Informix error -9004

Direct mail bounced... Sridhar Mahankali writes: ->... ->Could any of you Informix gurus enlighten me as to what this error signifies ->and whether there is any error in the above modification. ->... At the operating system prompt type: finderr 9004 And you will get: -9004 The column name is not in the current table, or the user variable name has not been defined. The name shown cannot be related to either a column in a database table or a defined variable. Check its spelling. If you meant it to be a variable, add it in the DEFINE section. If you meant to name a column in the database, check to see if the table has been altered or its columns have been renamed. ->modification: if close1a = "X" and update1a = today and level_chng1a != "X" then Probably one of the variables: close1a, update1a, or level_chng1a has not been defined. ->Thanks in anticipation, I hope this helps! Regards, - Cathy -------------------------------------------------------------------------------- Cathy Kipp e-mail: ckipp@vth1.vth.colostate.edu Phone: (303) 491-1294 Colorado State University Veterinary Teaching Hospital Fax: (303) 491-1205 Coming in late summer, from Prentice Hall, my new book: Programming INFORMIX SQL/4GL: A Step-by-Step Approach (ISBN: 0-13-149394-9)