Dear when I go to search the Item with lower case. program reached end of file. my all Items name are in upper case.

pls help

Hi,

I have moved your post to a new thread. Can you please provide more info about your case?

From what I understand, you can use the toupper$() function (http://www.baanboard.com/programmers_manual_baanerp_help_functions_string_operations_tolower_toupper) to convert your string to uppercase.

- George

Dear

This is a display session. when search the item description and put in lower case file reached end of file. our all items are upper case. Script attached


declaration:

table tticus002 | Item Description (Customized)
table ttdpur041
table ttdsls041
table ttibom010


extern domain tcitem item
extern domain tcmcs.str16 sess.name





|****************************** Zoom section ***************************

zoom.from.all:
on.entry:

import("prog.name$",sess.name)
if sess.name = "tdpur4105s000" then
import("tdpur041.item",ticus002.item)
else
if sess.name = "tdsls4105s000" then
import("tdsls041.item",ticus002.item)
else
if sess.name = "tibom1110m000" then
import("tibom010.mitm",ticus002.item)
endif
endif
endif
|execute(find.data)


on.exit:
item = ticus002.item
if sess.name = "tdpur4105s000" then
tdpur041.item = item
export("tdpur041.item",item)
else
if sess.name = "tdsls4105s000" then
tdsls041.item = item
export("tdsls041.item",item)
else
if sess.name = "tibom1110m000" then
tibom010.mitm = item
export("tibom010.mitm",item)
else
endif
endif
endif
|execute(find.data) |Anish

Are you talking about a using the tools query option (ttstpqbf)? I am not sure you can force that to upper case.

Dear

This is my display session. When I search thro binocular and put item name in lower case, its reached end of file (not search). but when I put in upper case then ok got the item from item table.

our item name are in capital.

pls help

thanks

S K Gupta

Dear

This is my display session. When I search thro binocular and put item name in lower case, its reached end of file (not search). but when I put in upper case then ok got the item from item table.

our item name are in capital.

pls help

thanks

S K Gupta

Hello,

use toupper$() on this field.

Regards

Dear

toupper$() will use in script or on form or stnd opt on form.

waiting your reply

Here is a sample of how I use it in a script:

field.advice.printer:
before.input:
if prnt.advice <> tgyenox.yes then
advice.printer = ""
attr.input = false
endif

after.input:
|* 20041222.st - Printer defaults as requested
advice.printer = toupper$(advice.printer)
shortage.printer = advice.printer
outbound.printer = advice.printer
display("shortage.printer")
display("outbound.printer")

You may need to use it in the before.zoom section on the field.

Dear

I need solution for my script. I did not want to much change in current script because it is working fine only problem is case (lower and upper).

at the time of "FIND" option (to display the item by our customize session ticus0102s000) I have problem.

pls help

Use the function suggested by other Guru in the follwoing manner.


field.ticus002.xxxx:
when.filed.changes:
if choice = def.find then |u may skip this condition if u want case conversion always
ticus002.xxxx = toupper$(ticus002.xxxx)
endif


More better u can write the above code in before.checks section also .

Dear

This session is running ok with first order - Item code - this will search with any case (lower or upper).
but when we use second order - {Desc (Domain - tcmsc.str60)+ item code} - this will not search in lower case

*****************************
21/06/2007

Dear

I checked that our customize table description data type is string. Hope this is a problem. In standard tiitm001 description is Multi Byte string and this work in both ways.



thanks

Dear

I checked that our customize table description data type is string. Hope this is a problem. In standard tiitm001 description is Multi Byte string and this work in both ways.



pls help