[development-axapta] Re: Enum
Hi If its global - use configuration keys on each element If only in screen form - there is no such possibility. The easiest way is to create different enum like AddressTypeLocal with neccessary elements and use this in forms. And when modifying if, you must save the correct enum element value to AddressType in table br Ingus Ziedins --- In development-axapta@yahoogroups.com, Pooja . dyna.a...@... wrote: There is enum called Addresstype in address table. in my requirement,I need to see all enum elements init,I need first three only. How to disable rest of all. thanks [Non-text portions of this message have been removed]
[development-axapta] Re: Like Operator
Hi Use qbr_salesline.value('9*'); br Ingus Ziedins --- In development-axapta@yahoogroups.com, branjema branj...@... wrote: i'm trying to use the like operator in a query: qbr_salesline = qbs_salesline.addRange(fieldnum((salesline,invoiceaccount)); qbr_salesline.value('like 9*'); But its not working. Does someone know the answer?
[development-axapta] Re: Mathmatical Expression in ax
Hi You can store the expression as string and afterwards replace variables with any values you like The easiest way to replace them is to store expression string as %1 + %2 + %2 + %2 And replace variables with strFmt() then use evalBuf() to execute string expression example with steps: str = s; str = expression; real = r; ; s = %1 + %2 * (%3 / %4) / (%4 * %5) expression = strFmt(s, value1, value2, value3, value4, value5); expression = strReplace(expression, ',', '.') r = evalBuf(expression); strReplace was needed because of my regional settings - decimal delimiter is stored as comma ','. Expression must be with dots '.' Only restriction is to write correct expression syntax in string best regards Ingus Ziedinsh --- In development-axapta@yahoogroups.com, naveed ali naveed_jadoo...@... wrote: Hi, I have mathmatical expression like a+b(c/d)/(d*e). My problem is how to save it in database table and reterive to perform some mathmatical operation.All these varaibles have some fixed values which is stroed in another table. Any help regardig this. Regards, [Non-text portions of this message have been removed]
[development-axapta] Re: Var or Cus layer
Hi As I know, VAR layar contains no global solutions such as country/ regional modification or microsoft fixes. VAR is common layer for third party modification implementation. That meens you cant get any documentation from anywhere else than the company created or modified previously created var layer. The same with CUS layer. Standard axapta contains empty layers - BUS, BUP, VAR, VAP, CUS, CUP, USR, USP - availability differs from purchased license. Only difference is AOT table id numbers There can be difficulties transfering VAR to CUS because data can be lost if not recoded SQLdictionary correctly. But maybe there are tools for this purpoose. SQLDictionary table contains Ax tableId reference to database Id, So if some table changed layer, it most probably changed its ID and the old one must be changed to new in SQLDatabase table. I believe CUS contains 4 - 4 ID's and Var 5 - 5. But again - no difference in what layer code exists, if it only is on the top layer. Othervise only upper level code will execute. BR Ziedinsh --- In development-axapta@yahoogroups.com, S. Umit akme...@... wrote: Hi all, One of the clients asked me that her company is using VAR layer - when they purchased it, the third party sold and installed the VAR layer on their server. She wants to change that layer to CUS layer -perhaps some admin purposes. There is no detailed info about these layers specifically for the business point of view, or I am not aware of it yet. Can somebody let me know the differences between these two layers? Especially the usage/modifications/financing/promos are concerned? Thanks in advance. Umit [Non-text portions of this message have been removed]
[development-axapta] Re: reding PPT file in Axapta ????
Hi With ppt you mean PowerPoint document? I dont know what information you could read in axapta, but you can run the file from axapta as an ordinary file - it will open in microsoft power point - winapi::shellExecute('C:\\filename'); use double backslash in place of one, otherwise it will not work. best regards Ingus Ziedinsh --- In development-axapta@yahoogroups.com, amitsinha_tinu [EMAIL PROTECTED] wrote: hello All, i am new in this field(Ax) and just joined the group.. My question is Is it possible to read PPT file in axapta..?? As we can read Excle file via a COMvariant.. Actually i have a PPT file and a Excle file ..i able to read Excle file but don't know how to read PPT file in Ax .. please Reply Soon its URGENT thanks REGARD Amt
[development-axapta] Re: Persistent data
Hi Do you mean more than one record? You can insert as much data you like :) When you set the tmp table data in application class the first time it will live there all session time and be updated when updated the same cursor table anywhere in axapta. That means that when you declare a tmp table in another class and get its data from appl class as tmpTable = appl.getDataFromTmpTable() it gets the same instance of tmp table as in application class. It will automatically update the tmp table in appl class if you update the local tmp table. The same with deletion and updating. br Ingus Ziedins --- In development-axapta@yahoogroups.com, jquinteroz [EMAIL PROTECTED] wrote: Hi!, thanks. Does it works for many data ocurrences?. --- In development-axapta@yahoogroups.com, zed@;=9A?= zed@ wrote: Hi I would use Application class - Declare a variable in class declaration Mak an setting/getting method like tempTable tempTableSetGetMethod(tempTable _tempTable = tempTable) { ; tempTableVariable = _tempTable; return tempTableVariable; } ang call it from any place in axapta - appl.tempTableSetGetMethod; best regards Ingus Ziedinsh --- In development-axapta@yahoogroups.com, jquinteroz jquinteroz@ wrote: Hi!: I need to share between many differents classes a temporary data (it only must exist in the session time). I created a temporal table but this data seems to be seen only by the application that instance it first. For a while, I am using a normal table like temporal data repository, but, I need to use delete to eliminate the data. Does exists a better way to do that?.
[development-axapta] Re: Persistent data
Hi I would use Application class - Declare a variable in class declaration Mak an setting/getting method like tempTable tempTableSetGetMethod(tempTable _tempTable = tempTable) { ; tempTableVariable = _tempTable; return tempTableVariable; } ang call it from any place in axapta - appl.tempTableSetGetMethod; best regards Ingus Ziedinsh --- In development-axapta@yahoogroups.com, jquinteroz [EMAIL PROTECTED] wrote: Hi!: I need to share between many differents classes a temporary data (it only must exist in the session time). I created a temporal table but this data seems to be seen only by the application that instance it first. For a while, I am using a normal table like temporal data repository, but, I need to use delete to eliminate the data. Does exists a better way to do that?.
[development-axapta] Re: Scanning Barcode in SalesLine
Hi Try using method InputSearch on SalesTable form - SalesLine grid - ItemId Preview: public void inputSearch(str _searchStr) { ItemId findItemId; InventTable inventTable; ; //super(_searchStr); findItemId = InventItemBarCode::findBarcode(_searchStr,false,false).itemId; if(findItemId) SalesLine.ItemId = InventTable::find(findItemId).ItemId; ... } best regards Ingus Ziedinsh --- In development-axapta@yahoogroups.com, ajastra_1 [EMAIL PROTECTED] wrote: Hi All, I am trying to scan barcode for inserting Items in SalesLine. I am using EAN13 Barcode Type and I have attached the barcode Number to one of the Item in Items Setup Barcode Setup. Also I have selected the scanning option. Now at the time of creating Sales Line, I want functionality as If I put the cursor on ItemId and scan the Barcode then it should take the related Item of that barcode. I have tried the same but not able to solve.But, If Search Name of the Item is same as Barcode number then the funtionality is working fine, but it will create problem in case of multiple Inventory Dimension Combinations. Can anyone please tell me the solution of above problem on urgent basis since my work is stuck on this point. Thanks in advance. Regards, Ashish Patil.
[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]