Hi all,
I used to use the % and # for wildcard searches in Servoy 2.2.7 and 3.1 but i’m trying out servoy 3.5, and the % doesn’t seem to work. I simply hit Cntrl F to go to find mode and then type in %A% anything with the letter ‘A’ to be returned in my foundset, but instead it returns 0 records. any ideas?
Servoy Developer
Version 3.5-build 513
Java version 1.5.0_02-b09 (Windows 2000)
No problem here in 3.5 (final release) … I tried the exact string %A% (16 records out of my test database of 1000 rec’s) and %a% returns 400+ records.
Case sensitivity maybe on your backend db?
Michael Mooney:
No problem here in 3.5 (final release) … I tried the exact string %A% (16 records out of my test database of 1000 rec’s) and %a% returns 400+ records.Case sensitivity maybe on your backend db?
I see what i’m doing wrong, I’m trying to do a wildcard search on numbers. I tried using % on numeric field and it won’t work.
no, but how do you do wildcards on numeric values? If i do %10%, it won’t return all records with 10 in it…help!
Glad you got it!
no, but how do you do wildcards on numeric values? If i do %10%, it won’t return all records with 10 in it…help!
It sounds like you are trying to do something like a substring search within an Integer/numeric (? … sounds like it anyway).
SQL calls originating from the Find screen are going to honor the data type (as seen in the data provider) … so I don’t think Servoy will pass a substring down for searching in an Integer field. At least if I was designing software for this I wouldn’t go down that road.
What is your data type?
Would be nice if Servoy would do a “to_string” search when a users enters a % wildcard in a number field !!