[Axapta-Knowledge-Village] Re: How to change and get a criteria value in RunBaseBatch

2007-09-13 Thread chuiringo 
Hi,

The following coding to show that if the table field 
vendPackingSlipTrans.qty is equal to
VendPackingSlipTras.ESG_AllocateQty that the recode will not 
displayed in the form. But I want to amend it.

qbRange = this.query().dataSourceTable(_tid).addRange(fieldnum
(vendPackingSlipTrans, DataAreaID));
qbrange.value();
qbrange.value(strFmt('(%1 != %2)',fieldstr(VendPackingSlipTrans, 
Qty),fieldStr(vendPackingSlipTrans, ESG_AllocatedQty)));


Actually in the form have many fields are displayed and one field is 
getting from table data method showOnHandQty.
In my case, I want to amend this form that if the 
method showOnHandQty is equal to 0.
The recode will not displayed in the form. Have any idea?

Table (VendPackingSlipTrans)
Method (showOnHandQty)

The coding of showOnHandQty
public display real showOnHandQty()
{
realrVal = 0 ;
InventTrans _inventTrans;
InventSum   _inventSum;
InventDim   _inventDim;

while select _inventTrans
where _inventTrans.InventTransId == this.InventTransId
 _inventTrans.PackingSlipId == this.PackingSlipId
{
_inventDim = _inventTrans.inventDim();
select _inventSum
where _inventSum.ItemId == _inventTrans.ItemId 
_inventSum.InventDimId == _inventDim.inventDimId;
rVal += _inventSum.AvailPhysical;
}

return rVal;
}

regards,

--- In Axapta-Knowledge-Village@yahoogroups.com, Steeve Gilbert 
[EMAIL PROTECTED] wrote:

 How do you set a criteria on a table method?
 
 --- In Axapta-Knowledge-Village@yahoogroups.com, chuiringo 
 chuiringo@ wrote:
 
  Thank you for your reply..
  
  One more question in (1).
  If the query field(virtual field) is get from the table method. 
How 
  to do it.
  
  Thanks
  
  --- In Axapta-Knowledge-Village@yahoogroups.com, Steeve Gilbert 
  steeve.gilbert@ wrote:
  
   Hi,
   
   1. You can get range value with this if you set range on 
   InventTable.ItemId :
   element.query().dataSourceTable(tableNum
(InventTable)).rangeField
   (fieldNum(InventTable, ItemId))
   2. I don't think that is possible.  But if it is, I don't know 
 how.
   
   regards,
   
   Steeve...
   
   --- In Axapta-Knowledge-Village@yahoogroups.com, chuiringo 
   chuiringo@ wrote:
   
Sorry, I am a beginner of axapter developer. I wrote some 
 report 
   and 
used ¡§qureyrun.get¡¨ function to get some needed recode to 
  output 
   to 
*.tsv files.

I want to now if somebody can help me 
1. How to get a criteria value and write it to report header 
in 
   output 
report file.
2. How to change date format in the criteria field that is 
not 
 in 
windows regional setting.

[Axapta-Knowledge-Village] Re: How to change and get a criteria value in RunBaseBatch

2007-09-07 Thread Steeve Gilbert 
How do you set a criteria on a table method?

--- In Axapta-Knowledge-Village@yahoogroups.com, chuiringo 
[EMAIL PROTECTED] wrote:

 Thank you for your reply..
 
 One more question in (1).
 If the query field(virtual field) is get from the table method. How 
 to do it.
 
 Thanks
 
 --- In Axapta-Knowledge-Village@yahoogroups.com, Steeve Gilbert 
 steeve.gilbert@ wrote:
 
  Hi,
  
  1. You can get range value with this if you set range on 
  InventTable.ItemId :
  element.query().dataSourceTable(tableNum(InventTable)).rangeField
  (fieldNum(InventTable, ItemId))
  2. I don't think that is possible.  But if it is, I don't know 
how.
  
  regards,
  
  Steeve...
  
  --- In Axapta-Knowledge-Village@yahoogroups.com, chuiringo 
  chuiringo@ wrote:
  
   Sorry, I am a beginner of axapter developer. I wrote some 
report 
  and 
   used ¡§qureyrun.get¡¨ function to get some needed recode to 
 output 
  to 
   *.tsv files.
   
   I want to now if somebody can help me 
   1. How to get a criteria value and write it to report header in 
  output 
   report file.
   2. How to change date format in the criteria field that is not 
in 
   windows regional setting.

[Axapta-Knowledge-Village] Re: How to change and get a criteria value in RunBaseBatch

2007-09-02 Thread chuiringo 
Thank you for your reply..

One more question in (1).
If the query field(virtual field) is get from the table method. How 
to do it.

Thanks

--- In Axapta-Knowledge-Village@yahoogroups.com, Steeve Gilbert 
[EMAIL PROTECTED] wrote:

 Hi,
 
 1. You can get range value with this if you set range on 
 InventTable.ItemId :
 element.query().dataSourceTable(tableNum(InventTable)).rangeField
 (fieldNum(InventTable, ItemId))
 2. I don't think that is possible.  But if it is, I don't know how.
 
 regards,
 
 Steeve...
 
 --- In Axapta-Knowledge-Village@yahoogroups.com, chuiringo 
 chuiringo@ wrote:
 
  Sorry, I am a beginner of axapter developer. I wrote some report 
 and 
  used ¡§qureyrun.get¡¨ function to get some needed recode to 
output 
 to 
  *.tsv files.
  
  I want to now if somebody can help me 
  1. How to get a criteria value and write it to report header in 
 output 
  report file.
  2. How to change date format in the criteria field that is not in 
  windows regional setting.

[Axapta-Knowledge-Village] Re: How to change and get a criteria value in RunBaseBatch

2007-04-27 Thread Steeve Gilbert 
Hi,

1. You can get range value with this if you set range on 
InventTable.ItemId :
element.query().dataSourceTable(tableNum(InventTable)).rangeField
(fieldNum(InventTable, ItemId))
2. I don't think that is possible.  But if it is, I don't know how.

regards,

Steeve...

--- In Axapta-Knowledge-Village@yahoogroups.com, chuiringo 
[EMAIL PROTECTED] wrote:

 Sorry, I am a beginner of axapter developer. I wrote some report 
and 
 used ¡§qureyrun.get¡¨ function to get some needed recode to output 
to 
 *.tsv files.
 
 I want to now if somebody can help me 
 1. How to get a criteria value and write it to report header in 
output 
 report file.
 2. How to change date format in the criteria field that is not in 
 windows regional setting.