Thanks Karen (and Dr R),
But this application almost always has SET MES OFF (unless I want an
informational message like how many rows where updated). The SET ERR MES
OFF will suppress system errors like when your Where clause results in no
rows found. Error message number 2059 (No rows exist or satisfy the
specified clause.)
I'm closing in on the problem which appears to be a poorly written where
clause in the Edit using Formname command below:
EDIT USING wkord_edit ORDER BY tk_sdate, wk_prty, eq_nbr, tk_desn, tk_nbr +
WHERE tk_sdate BETWEEN .sdate AND .edate AND tk_nbr IN +
(SELECT tk_nbr FROM tasks WHERE em_nbr = .emnew) AND +
(wk_stat IN (" ",c,i,x) OR wk_stat IS NULL) CAPTION "Work Orders (Open)"
I'll redo it tomorrow when I'm awake. I suspect it is the way I have the
parens.
The conditional setting for Error Messages that Dr Razzak spoke of will
make for much better use of error reporting/supression.
Dennis
****
At 07:38 PM 6/6/01 -0400, you wrote:
>Dennis:
>
>>SET ERR MES OFF
>
>>This works fine at the R>, but not once it is Codelocked. I get the "No
>>rows exits or ..." error message displayed. Checked all the usual
>suspects,
>>but no luck.
>
>I think this particular message is governed by SET MESS OFF, not ERR MESS.
>It isn't technically an error, it's a warning. Try SET MESS OFF
>
>
>Karen
>
>
>
>
Dennis Fleming
IISCO
http://www.TheBestCMMS.com
