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
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
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
-
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
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
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]
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
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
-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
9 matches
Mail list logo