Pervasive IsNumeric ?

[Johnny42]

SELECT * FROM sales WHERE IsNumeric(left(ID,1))

will this work ?

 

[mirtheil]

What version of Pervasive are you using? I've got 8.6 with an FTF and the following statement works for me using Demodata:
SELECT * FROM class WHERE IsNumeric(left(section,1)) = 1

IsNumeric seems to return 1 for true and 0 for false.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com

 

[Johnny42]

Soory I tried :

SELECT * FROM "ICITEM" WHERE IsNumeric(left(ITEMNO,1)) = 1

got this back :

ODBC Error: SQLSTATE = 37000, Native error code = 0
Invalid scalar function: IsNumeric.

using 8.00.114.000

I found this ....?
Appendix 8--ISO Utility and Information Modules

A8.1 Characters and Strings
DEFINITION MODULE CharClass;

(* Classification of values of the type CHAR *)

PROCEDURE IsNumeric (ch: CHAR): BOOLEAN;
(* Returns TRUE if and only if ch is classified as a numeric character *)

 

[mirtheil]

What version of Pervasive.SQL are you using? Might be time to open a support incident.


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com

 

[Johnny42]

using 8.00.114.000

 

[mirtheil]

That's the original release of 8.0. You might want to try 8.6 first and if that doesn't work, then call Pervasive.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com