manojsharma
12th April 2003, 09:18
hi all,
Normally, when we zoom on supplier code, we have to again search no supplier name to find out exact supplier code.
Now, I want that when I type the supplier code, my zoom session will automatically show the supplier code on the basis of typed code and should be shown parralelly.
Thanx in advance
Manoj Sharma
mark_h
13th April 2003, 05:20
Is this a zoom session you wrote or is it a Baan standard zoom session? Usually if you are zooming to a Baan standard session, then it executes a find first. So in the before.zoom section of the field(in the calling session) you set the table fields needed for the find.
If this is your own zoom session you need to make sure your startup option on the zoom session is find. Then in the calling program use the above to set the table fields.
Mark
manojsharma
28th April 2003, 12:20
no no
I just want that as soon as I start typing the supplier code, my zoom session will be automatically sorted on the typed keys.
for example,
my supplier code start with "S", as soon as I type SR, my zoom session should be automatically sorted on the supplier whose name starts with "R".
Thanx in advance :)
OmeLuuk
28th April 2003, 14:28
If you do enter like "SY," [Zoom] (note the comma), you will see the SY* and next records in the zoomsession.
So use "," as a kind of wildcard.
manojsharma
28th April 2003, 14:54
no, its not working
mark_h
28th April 2003, 16:09
Which one of the sub-sessions are you zooming to? You may need to fix the zoom session itself - on our system tccom2510s000 does not work like what we have described, yet others like tppdm9556m00b do.
Mark
gfasbender
28th April 2003, 18:41
Supplier (tcsuno) is right-justified domain, so you would have to do some coding before the zoom. "^^^^SY" won't position itself at "SY0000", but "SY^^^^" would, where "^" is a space.
zardoz
28th April 2003, 18:41
It's seems that manojsharma ask for an impossible solution (in std baan sw).
Omeluuk also says that it's possible to search with wildcards, but this isn't a standard functionality. This is done by writing code. In many (but not all) the sessions, when you search for an Item code, for a Customer code, for a Supplier code, if you put a comma after the key you search, a search on alternative key is done instead. So manojsarma can search for a name of supplier that starts with "R" but there is no way to search also automatically for the code that starts with "S" togheter. (And I cannot figure why there is a need of such a search....)
OmeLuuk
28th April 2003, 18:45
zardoz: (And I cannot figure why there is a need of such a search....)Maybe because it is done like that in the Redmond factory?
NPRao
28th April 2003, 20:34
Manoj,
I am not sure if this function is valid in BaaN-4 series or not.
But you can use - query.extend.where.in.zoom() (http://www.baanboard.com/programmers_manual_baanerp_help_functions_sql_query_extensions_query.extend.where)
manojsharma
30th April 2003, 08:10
hi,
thanx all for your valuable suggestion.
Actually, in foxpro I have already developed the session but in baan I don't know how to do it
Anyway thanx all.