lowndes
5th January 2006, 08:04
:confused:

I want to refresh a session by a variable but not the table field.
For example , i generate one session based on tdsls401 , also , i create a
enumerated varibale for every record in the form. Now , i want to refresh this session by this enumerated varibale according to different terms .
So,who can help me?
Thanks !

mr_suleyman
5th January 2006, 08:42
Hi , you can use execute(find.data) command in your terms like following
if enumereted.varibale = ?????? then
execute(find.data)
endif

That's all I think



Good LUck !!!

bdittmar
5th January 2006, 10:04
:confused:

I want to refresh a session by a variable but not the table field.
For example , i generate one session based on tdsls401 , also , i create a
enumerated varibale for every record in the form. Now , i want to refresh this session by this enumerated varibale according to different terms .
So,who can help me?
Thanks !

Hello,
i think you have to explain more details about your need.
Do you wanna refresh only the information on form ?
Not clear ?
??????

Regards

lowndes
6th January 2006, 04:55
Hi , you can use execute(find.data) command in your terms like following
if enumereted.varibale = ?????? then
execute(find.data)
endif

That's all I think



Good LUck !!!


I'm afraid it's not correct .Thank you all the same.

lowndes
6th January 2006, 05:30
Hello,
i think you have to explain more details about your need.
Do you wanna refresh only the information on form ?
Not clear ?
??????

Regards

Sorry, I will show you an example.
There is a session tdsls4501m000 based on table tdsls401. In the form ,the majority fields is the table fields , but there is a variable field called "field.status" . I use this field to describe the status of the order line.
I give this field some values such as "planned","started","completed"…….Of course , this value is evaluated by another table according to some relation.
But these two tables don't have references.
Now , I want to refresh this session by this field. I need to display the "planned" order line or "started"order line and so on .

darpan
6th January 2006, 12:57
Mr. Suleyman is absolutely correct .

first import data thru zoom process.or update thru table and then call execute(refresh).

Hope it shuld work

Take Care

All the Best

Darpan

mr_suleyman
7th January 2006, 12:34
Why do you try to QUERY.EXTENSION command for your case. look at following
I see that you try to execute query according to your special field value. Then you should use query.extension command and refresh your display session.
For example enumared table field is tdsls401.xxx (tdsls401.xxx =1 means planned)
you can improve this condition that depends on your customized field.

if field.status = planned then
query.extension = ("tdsls401.xxx = 1")
rebuild.query()
execute(find.data)
else
| **********write other conditions*************
endif
Good Luck !!!

lowndes
9th January 2006, 02:59
Why do you try to QUERY.EXTENSION command for your case. look at following
I see that you try to execute query according to your special field value. Then you should use query.extension command and refresh your display session.
For example enumared table field is tdsls401.xxx (tdsls401.xxx =1 means planned)you can improve this condition that depends on your customized field.

if field.status = planned then
query.extension = ("tdsls401.xxx = 1")
rebuild.query()
execute(find.data)
else
| **********write other conditions*************
endif
Good Luck !!!



The variable is just a commom variable . So , I'm afraid there isn't any relation bewteen table field and this variable.The value of this variable is caculated by other tables . And , I just wanna refresh the display according to this variable . Is it possible to realize?
Thank you very much!

csecgn
9th January 2006, 10:24
I'm not so familar with Baan V. In BaanIV I would use execute(interrupt) for refreshing the display. Maybe in V it's the same.

Regards
csecgn

manojsharma
9th January 2006, 12:50
can u paste the screen shot of your session which help us to understand better.

en@frrom
11th January 2006, 13:14
If I understand well, all you need is display("<field_name>")

NPRao
11th January 2006, 20:32
if field.status = planned then
query.extension = ("tdsls401.xxx = 1")
rebuild.query()
execute(find.data)
else
|**********write other conditions*************
endif
The statement - execute(find.data) is redundant.

|******************************************************************************
function extern mismatch.records()
{
query.extension = "zmmig104.cnt1 <> zmmig104.cnt2"
rebuild.query()
}
|******************************************************************************
function extern showall.records()
{
query.extension = ""
rebuild.query()
}
|******************************************************************************

lowndes
16th January 2006, 05:27
Thanks for so many kind people.I go on errands for few days.I don't know how to paste the screen of my session ,so, I will show you the example in my attachment.

Rita Kotecha
16th January 2006, 08:13
Hi,

Try this. In the before.display.object section assign values to the common variables.

Hope it helps.