Re: Not a number check in Informix 4gl

Posted in 2003

Mark D. Stock — Tue, 23 Sep 2003 11:54:18 +0100 — source: Usenet: comp.databases.informix

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