I tried using RETRY as the name of a column, and as the name of a stored procedure parameter, and as the name of a stored procedure variable.
This produced no error messages of any sort at all anywhere, but the wrong value for the column got inserted into the table: INSERT INTO MYTABLE( ..., RETRY ) VALUES ( ..., :RETRY ); inserted zero when the value of the parameter RETRY appeared to be 1 (in the Database Workbench procedure debugger - yes I know that doesn't prove what it is when the procedure is run normally in Firebird, but I still get zero in the column). On changing all the RETRY names to something else the right value got inserted into the table. I can't find RETRY documented as any sort of reserved word in Firebird, and I can't find anything else called RETRY in our application. Any guesses as to what's going on? -- Tim Ward
