Hi there,
I have got an session that with a field that is converted to uppercase on input.

When i search on that field i always have to use uppercase.
I have to do that manually, is there a way to converte the searchargument in the searchbox to uppercase ?

:D

(tried before.zoom and before.checks but that didnt work)

Hi there,
I have got an session that with a field that is converted to uppercase on input.

When i search on that field i always have to use uppercase.
I have to do that manually, is there a way to converte the searchargument in the searchbox to uppercase ?

:D

(tried before.zoom and before.checks but that didnt work)

Hello,

maybe this will work :

field.yourfield:
before.input:

if choice = def.find then

toupper$(yourfield)

endif

Regards

Hello Bernd,

Thanks for your input, but when i search the program jumps to the befor.input section but doesnt reach the if statement as fas as i can see in the debugger.

Eddy


Hello,

maybe this will work :

field.yourfield:
before.input:

if choice = def.find then

toupper$(yourfield)

endif

Regards

Hello Bernd,

Thanks for your input, but when i search the program jumps to the befor.input section but doesnt reach the if statement as fas as i can see in the debugger.

Eddy

Hello Eddy,

then try it in choice section .

06 def.find Find a specific record on key 1234 ---4 1234
07 find.data Start the set from the current data in the program script. Use: after import of data in a zoom process. (refresh) 1234 ---4 1234

e.g..

choice.def.find:
before.choice:

toupper$(yourfield)

Regards

U may use after.input / when.field.change when choice=def.find to convert the field to it's upper case .

Alternatively before.checks also can work if domain used for the field has something to check at domain level.

Hello Eddy,

then try it in choice section .

06 def.find Find a specific record on key 1234 ---4 1234
07 find.data Start the set from the current data in the program script. Use: after import of data in a zoom process. (refresh) 1234 ---4 1234

e.g..

choice.def.find:
before.choice:

toupper$(yourfield)

Regards


he hi,

tried the before.choice, on.choice and after.choice but nothing seems to work for me.

he hi,

tried the before.choice, on.choice and after.choice but nothing seems to work for me.

Hello Eddy,

06 def.find Find a specific record on key 1234 ---4 1234
07 find.data Start the set from the current data in the program script. Use: after import of data in a zoom process. (refresh) 1234 ---4 1234

If your field is not in Key, try to use :

field.yourfield:
before.input:

if choice = def.find then
toupper$(yourfield)
endif

if choice = find.data then
toupper$(yourfield)
endif

One of the if statements should be hit.

Hope it helps.



Regards

Hello Eddy,

06 def.find Find a specific record on key 1234 ---4 1234
07 find.data Start the set from the current data in the program script. Use: after import of data in a zoom process. (refresh) 1234 ---4 1234

If your field is not in Key, try to use :

field.yourfield:
before.input:

if choice = def.find then
toupper$(yourfield)
endif

if choice = find.data then
toupper$(yourfield)
endif

One of the if statements should be hit.
Hope it helps.
Regards


Bernd,
Thanks for your reply, but still can't seem to get it working!
Does the program reaches this section (field.tdebn146.seak) when you do a search?
Eddy



field.tdebn146.seak:
before.input:
if choice = find.data then
tdebn146.seak = TOUPPER$(tdebn146.seak)
endif
|before.zoom:
|before.checks:
| tdebn146.seak = TOUPPER$(tdebn146.seak)
check.input:
tdebn146.seak = TOUPPER$(tdebn146.seak)

Hello eddy,

see attachmaent.

It's a session from 2007, and it works for me.

Table with two fields, manufacturer_number and manufacturer_name.

The Name has to be in Uppercase.


Find works, but not on Form !
If key is changed to name, the input is done in lowercase, but find is done in uppercase.

Regards

Bernd,

Thanks! that did the trick.
it must be in the after.input section !

:D thanks a lot !