This is a discussion on Re: Not a number check in Informix 4gl within the Informix forums, part of the Database Server Software category; --> malcolm.iiug wrote: > Why not copy the input string to a numeric data type and then copy the > ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| malcolm.iiug wrote: > Why not copy the input string to a numeric data type and then copy the > numeric data type to a string with a USING clause. If the input string is > equal to the result string then the data is numeric. > > I used to do this all the time in 3GLs. In 4GL, if you can copy the value to a numeric data type without an error, then your task is complete. ;-) The trick is switching on the correct level of error trapping. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list |