[Axapta-Knowledge-Village] Select statement Problem

2008-06-24 Thread mahesh_axapta
Hi All, I Have Very Strange Problem Regarding select statement. Whenever I Do Posting Of Sales Order,Purchase Order,Transfer Order On Hand quantity gets modified for respective item and warehouse.Also In Table browser Of InventSum it shows correct i.e updated values. But,whenever i try to

RE: [Axapta-Knowledge-Village] Select statement

2007-12-14 Thread Anders Sorensen
is provided AS IS with no warranties, and confers no rights. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Syner P Sent: 13. december 2007 09:20 To: Axapta-Knowledge-Village@yahoogroups.com; [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Select statement

[Axapta-Knowledge-Village] Select statement

2007-12-13 Thread Syner P
Hi, I have problem with a report query. In fetch method, I used 'while select' statement with several criterion. But when the user passes blank criteria, I want to use this like '*' in queries. But it doesn't work. Ex: If (!_ItemId) _ItemId='*'; while select InventTable where

RE: [Axapta-Knowledge-Village] Select statement

2006-06-05 Thread Harry Deshpande
- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of anton_tjiptadi Sent: 5. juni 2006 06:32 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Select statement Hi guys, I found one of select statement using key with nested_loop

[Axapta-Knowledge-Village] Select statement

2006-06-04 Thread anton_tjiptadi
Hi guys, I found one of select statement using key with nested_loop and force_placeholder can anyone tell me what it's means ? //SELECT WITH NESTED_LOOP, FORCE_PLACEHOLDERS * FROM InventDim... many thanks, Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta

Re[2]: [Axapta-Knowledge-Village] Select statement

2005-07-15 Thread setiaji kurniawan
Hello Dmitry, Thx Dmitry and Cenk.Its work :D Great thx guys... Thursday, July 14, 2005, 2:52:18 AM, you wrote: Try this inventTrans.Qty Axapta executes select statement in a little bit different manner than SQL. -- Best regards, setiajimailto:[EMAIL PROTECTED]

[Axapta-Knowledge-Village] Select statement

2005-07-13 Thread setiaji kurniawan
Guys,anyone can help me? select sum(Qty) from InventTrans where InventTrans.DatePhysical _startDate ; where can i get the value from the line above ? Refer to the Help Documentation, the value is in the field Qty in InventTrans tabel.But i cant get it. Is there any clue i can use to get the

YNT: [Axapta-Knowledge-Village] Select statement

2005-07-13 Thread Cenk Ince
inventTrans.Qty returns value :) Kimden: Axapta-Knowledge-Village@yahoogroups.com bu kişinin yerine: setiaji kurniawan Gönderilmiş: Çar 13.07.2005 12:30 Kime: Axapta-Knowledge-Village@yahoogroups.com Konu: [Axapta-Knowledge-Village] Select statement Guys

RE: [Axapta-Knowledge-Village] Select statement

2005-07-13 Thread Dyachenko, Dmitry
-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Select statement Guys,anyone can help me? select sum(Qty) from InventTrans where InventTrans.DatePhysical _startDate ; where can i get the value from the line above ? Refer to the Help Documentation, the value is in the field Qty