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/
[U2] [UV] controlling selects with "unconverted data used for selection" errors
Buss, Troy \(Logitek Systems\) Thu, 11 Nov 2004 11:24:36 -0800
- RE: [U2] [UV] controlling selects with &quo... Buss, Troy \(Logitek Systems\)
- RE: [U2] [UV] controlling selects with... Brian Leach