Re: [development-axapta] Select statement
Hi Syner, You can use like in your while statement. Syner P [EMAIL PROTECTED] wrote: 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 ItemId==_ItemId ... Any help appreciated. Syner __ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping [Non-text portions of this message have been removed] - Looking for last minute shopping deals? Find them fast with Yahoo! Search. [Non-text portions of this message have been removed]
[development-axapta] Re: Select statement
Hi Use like instead of * while select inventTable where inventTable.itemId like _itemId br Ingus Ziedinsh --- In development-axapta@yahoogroups.com, Syner P [EMAIL PROTECTED] wrote: 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 ItemId==_ItemId ... Any help appreciated. Syner Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/ newsearch/category.php?category=shopping [Non-text portions of this message have been removed]
RE: [development-axapta] Select statement
Hi from * i think you mean all if yes then you dont need to assign * to itemid you just assign itemid='' by this way it select all records for referenece visit this link may this help you http://www.axaptapedia.com/Expressions_in_query_ranges M Amir NazimSoftware Engineer MazikPakistan - Dynamics DivisionEmail : [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]: [EMAIL PROTECTED]: Thu, 13 Dec 2007 00:20:19 -0800Subject: [development-axapta] 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 InventTablewhere ItemId==_ItemId...Any help appreciated.Syner__Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping[Non-text portions of this message have been removed] _ Don't get caught with egg on your face. Play Chicktionary! http://club.live.com/chicktionary.aspx?icid=chick_wlhmtextlink1_dec [Non-text portions of this message have been removed]
[development-axapta] temptable
Hello, I have 2 grids on the same form. The top grid contains SalesLine records. The bottom grid contains external data which is bound to a temptable. I have no problem to display the SalesLine data in the top grid. What I wanted to do was that when the user clicked on a record - SalesLine - or on a grid row, a process will populate the temporary table with external data by a calling a store procedure. I was able to achieve this task by calling the Active mehtod. Everything is working fine with the exception of refreshing the grid which bound to the temptable. I checked the process by inserting info() statement in a function to see if the records are inserted correctly in the temptable and they did. Now the problem is to refresh the grid to display the current data. For some reason, it always displayed the data that were return in the FormRun.init(). Can someone help me? Thanks!
RE: [development-axapta] Dimensions hierarchy - filtering
I think the ledger parameter needs to be 'posting and entry' _ From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of gabryelczyk Sent: 11 December 2007 19:52 To: development-axapta@yahoogroups.com Subject: [development-axapta] Dimensions hierarchy - filtering Hi all, I have set dimensions hierarchy Deoartment-Centre. It means that for specified Department only specified Centres are acceptable. In ledger parameters field Acivate stes I have set for 'At update and posting'. In hierarchy rules I have connected this hierarchy to specified ledger accounts. When I use this account in ledger journa, when I choose Department i Centre field I see all Centres. I thought I should see only Centres connected to specified Department. When I check journal, the system checks connection Departnet-Centre correctly. What to do see on the Centre list only centres connected with choosen department ? Thanks in advance Pawel Gabryelczyk [Non-text portions of this message have been removed]
[development-axapta] Create Document handling Form
Hello, I have a small query on document handling. I have to add a lot of texts on sales order document. These texts should be predefined. It will be necessary to have the ability to have some table to choose a specific text top print on the document. Now I have created a new table and a form. This form is called from Sales order form by a menuitem button. In this form I should enter the notes and press a button in that form to transfer the text to standard AX document form. The whole idea is that we don't want to enter the fixed text from order, we want to choose an amount of text to print. we need to have some kind of table where all fixed text is stored, thats the whole idea of this functionality. When we want a fixed text on sales order we will be able to choose any text to transfer to the document handler. I think you got it. Can you let me know how to do the same? I am new to document handling. Rgrds, Raj
[development-axapta] RE: [Axapta-Knowledge-Village] Select statement
Hi, You could also do like this: While select InventTable Where (InventTable.ItemId == _itemid || !_itemid) This will limit the query to get a single item if the parameter has been filled out, and all items will be fetched if it has not been set. Regards, Anders Sorensen This posting is provided AS IS with no warranties, and confers no rights. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Syner P Sent: 13. december 2007 09:20 To: [EMAIL PROTECTED]; development-axapta@yahoogroups.com 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 ItemId==_ItemId ... Any help appreciated. Syner __ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]