RE: error message

If you have a long SQL statement and try to figure out where exactly caused the error, try run the sql statement in SQL Editor version2/version3. u will still get the -201 error but it will atleast hightlight the place in the sql statement which might cause the error. hope this will help. cheers YFWoi -----Original Message----- From: Robert Stuart [mailto:Robert.Stuart@nfer-nelson.co.uk] Sent: 22 November 2000 16:29 To: 'Jvrn Staack'; informix-list@iiug.org Subject: RE: error message Please let us know a bit more - like the SQL code and or the program code just before the error. Running finderr often gives you a clue - but -201 is too general to answer your question. My (antiquated) version of finderr gives... $> finderr -201 -201 A syntax error has occurred. This is the general error code for all types of mistakes in the form of an SQL statement. Look for missing or extra punctuation (for example, missing or extra commas, omission of parentheses around a subquery, etc.), keywords misspelled (for example VALEUS for VALUES), keywords misused (for example, SET in an INSERT statement, INTO in a subquery), keywords out of sequence (for example a condition of "value IS NOT" instead of "NOT value IS"), or the use of a reserved word as an identifier. (Note: Database servers that support "full NIST compliance" do not reserve any words; queries that work with these database servers may fail with error -201 when used with earlier implementations.) -----Original Message----- From: Jvrn Staack [mailto:joernstaack@gmx.de] Sent: 21 November 2000 23:32 To: informix-list@iiug.org Subject: error message Hi i want to past an english text into an informix database. But then appears the following error: Exception from Informix: X42000:-201:Syntax error or access violation Whats wrong ??? Thanks for the help! Joern