Using universe 10.0.19...
 
When a user provides an invalid date value for a select, universe prints
out the error message "bad data.... unconverted data used for selection"
but goes on and does the select.
 
Is there a way to:
 
1. require that the retrieve command fail when this occurs by using a
keyword similiar to REQUIRE.INDEX as in REQUIRE.NO.ERRORS ?
 
or 
 
2. be able to get a result code from the command via the 'RETURNING
ERRORS' clause of an execute statement?
 
 
Personally, I think the command should outright fail when this occurs
rather than wasting the user's time and/or provding results that are not
what was intended.
 
Sample:
 
SELECT SOLI WITH DATE "2/31/04"
Bad data "2/31/04" for conversion "D2-".  Unconverted data used for
selection.
-- select proceeds for 2 minutes with zero items selected --
 
 
-Troy
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

Reply via email to