Normal Topic [BRF] Search in number field does not work (Read 470 times)
assistent
Member
*
Offline



Posts: 11
Joined: Feb 11th, 2008
[BRF] Search in number field does not work
Feb 25th, 2008 at 3:25pm
Print Post Print Post  
When searching in number or currency fields, i get no results! not even in the demo files from Sesame.
f.i. in database customers.db : if i search for customer key numbers < 1000 : no results will appear

I use Sesame 2.05 version, and have Dutch version of Windows. (meaning that decimal separation char = "," and thousands = ".")

Displaying and editing dates and numbers however works fine with our international settings.

I had a same kind of "international" problem in a previous case, displaying the dates and numbers in the correct format in Sesame 1.1.4,  which was solved by changing settings of the number fields within the Sesame form. (changed the decimal character to ",") 


The fact is that when i change the country settings of my Windows to US english,  the searching in number fields simply works fine.
but is no option to work with.

Any suggestions to solve this?
« Last Edit: Mar 5th, 2008 at 9:01pm by Hammer »  
Back to top
 
IP Logged
 
Ben
Lantica Support
*****
Offline



Posts: 218
Joined: Apr 7th, 2005
Re: Search in number field does not work
Reply #1 - Mar 5th, 2008 at 8:48pm
Print Post Print Post  
This has been written up and reported to development. A fix for this should be in the next update (2.0.6).
-Ben
  
Back to top
IP Logged