I normally use VAR MATCHES '1N0N]1N0N"."1N0N' where ] is a value mark.
Different strokes, I guess. There are many ways to skin a cat, but no
matter which one you use, the cat ain't gonna like it.
Charlie
On 05-08-2013 9:38 AM, George Gallen wrote:
I Usually use NUM(xx) and xx#"" to combat that one.
Never really thought about "." - I would think that would be treated as 0.0 in
any calculations?
Guess I'll have to test that one out...
George
-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
Sent: Wednesday, May 08, 2013 10:34 AM
To: U2 Users List
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
NUM() will validate '' (null string) as numeric, and I believe some
implementations would validate '.' (decimal point) as numeric, although
the version of Jbase I'm on, running Universe emulation, does not.
Charlie
On 05-08-2013 8:39 AM, George Gallen wrote:
The only thing I could think of is it could validate it as being a number, but
then
So would NUM().
George
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users