RE: [development-axapta] How do I dynamicly update field labels on a grid

be from data source, you should change the label of the form control. There is a labelText method of datasource field, only for reading. Sorry.. InventTable_ds.object(fieldnum(InventTable,ItemId)).labelText() Good luck, Anil OZAY From: development-axapta@yahoogroups.com

[development-axapta] Enum values in SQL database

Hi, We want to create a view on SQL server for InventTrans and tha table has enum values. SQL uses integer values to store enum values but we want to show enum values to user. Is it possible to find the enum values on database to show in the view? Regards, Anil Ozay

[development-axapta] Reading COM Port from Dynamics AX 3.0

Hi gurus, We have a machine and connected to COM port of PC, that has Dynamics AX 3.0. I have to read data from COM port. I search the internet and help files but I couldn't find anything. Do you know, how can I do this ? Anil OZAY [Non-text portions of this message have been

RE: [development-axapta] How To Find Persons who born today ? (birthdate)

Hi Ali, EmplTable EmplTable; TransDate today; ; Today = today(); WHILE SELECT EmplTable WHERE EmplTable.BirthDate == today { info(EmplTable.Name); } Regards, Anil Ozay Freelance Consultant MVP Dynamics AX, MCPS, MCNPS, MBSS Uzman Nokta

RE: [development-axapta] Show hidden field in table browser

can't see hidden fields in tableBrowser. May be you can change the functionality of SysTableBrowser, but it's hard. Regards, Anil Ozay Freelance Consultant MVP Dynamics AX, MCPS, MCNPS, MBSS Uzman Nokta Bil.Hiz. From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED

RE: [development-axapta] Install Axapta 4 server in Windows XP

Hi Venkat, If your computer is in the domain, you can install Dynamics AX to Windows XP. Log on the your XP with domain acoount, and just install. Don't worry about 'Windows 2003 required' message it will be installed successfuly. Regards, Anil Ozay Software Eng., Dynamics Ax

[development-axapta] Updating selected records

records without lost the marking. I use ds.executeQuery(), it works but I lost selected records and cursor goes to first record of the grid. This is very important for us. I will really appreciated, if anyone can solve this problem. Best regards, Anil Ozay MVP Dynamics AX, Software Engineer

[development-axapta] Query Unpack

automatically, so I can't see ranges before user run the query. How can I catch the packed values of query ranges, programatically? Thanks, Anil Ozay [Non-text portions of this message have been removed]

RE: [development-axapta] Passing in a datasource

Hi Andre, You must use CallEx() method if you want to pass more than 6 parameters. You can find a sample in Axapta Help File. Regards, Anil Ozay Software Engineer, AX Specialist MVP Dynamics AX From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf

Re: [development-axapta] Re: Auto-Increment

(NumberSequenceReference); this.Number = numberSeq.num(); If you want a sample to create new Number Sequence type, I can give a sample. Regards, Anil Ozay On 11/15/06, gokhaleanu [EMAIL PROTECTED] wrote: Hello Mr. Andre, First u have to run number sequence wizard. After that system creates its

Re: [development-axapta] AxaptaCOMConnector: Getting Existing Tables

);* *MessageBox.Show(tableName);* *}* *axaptaApp.Logoff();* *}* *catch (Exception ex)* *{* MessageBox.Show(Error: + ex.Message); *}* ** I hope this sample can help you. Best Regards, Anil Ozay MBSCP, MCP Software Engineer, Axapta Specialist Anadolu Group (www.bilisimanadolu.com) mail : [EMAIL

RE: [development-axapta] Switching Report Designs

); Return ret; } Regards, Anil Ozay Software Engineer, Axapta Specialist MBSCP, MCP Anadolu Group, ABH Inc. -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Martin Sujkowski Sent: Tuesday, November 29, 2005 4:05 PM To: development

RE: [development-axapta] Report Page break

. if(!firstRecord) { element.newPage(); } else { firstRecord = !firstRecord; } Super(); } Regards, Anil Ozay Software Engineer, Axapta Specialist MBSCP, MCP -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andre Klopper Sent

[development-axapta] Updating SQL Index Statistics

Hi all, I want to ask a critical question about Axapta. Can i update statictics from SQL Server? Is there problem about this? Bu e-posta ve muhtemel eklerinde verilen bilgiler kisiye ozel ve gizlidir. Anadolu Bilisim Hizmetleri A.S. bu mesajin icerigi ve ekleri ile ilgili hicbir hukuki

RE: [development-axapta] Form Query

Hi Hemant, You can give SQL criteria for range, but it must be in paranthesis. addRange( '(MyTable.MyField==A) || (MyTable.MyField==)') You must use double quote for range values. This is the solution ;) Regards, Anil -Original Message- From: development-axapta@yahoogroups.com

RE: [development-axapta] Setting up multiple portal on single machine

://development.thydatacenter.dk/ blocked:: http://development.thydatacenter.dk/ E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of ANIL OZAY Sent: 11. juli 2005 14:00 To: development-axapta

[development-axapta] Accessing report functions from query

Hi all, I have trouble when accessing report function from init function of Query of report. For ex, in the init method of query : str reportRange = element.parmRange(); How can i access it? Thanks for now.. Anil Ozay Software Engineer, MBSCP, MCP Anadolu Bilisim A.S. [Non-text

[development-axapta] Axapta Sizing Question

Hi all, I am trouble about one question from Axapta Installation and Configuration Exam.. Give me an idea about answer?? In a company, 10 users use Axapta Server.. After that 10 users added to system and system runs slowly. How we upgrade system : Old System : 1 *CPU Xeon 3.2 Ghz 1 GB Ram

RE: RE : [development-axapta] Beginner

Hi Kadar.. U must use container field on DB.. This example comes from X++ Advanced Course Manual.. I hope this example helps you.. Best regards, Anil Ozay  Add a new field to the table of type container.  Call the field ImageData.  There is a small issue with changing the underlying table

RE: [development-axapta] Activating a procedure after import

Hi Alex, I don't understand what you mean exactly, but SysImportDialog form used for importing projects.. In this form, u can find import() method for importing projects. This code calls SysImportElements class. You can extend this class for personal use.. For example, u can add a job file to

[development-axapta] Record Level Security Problem

/ Explode BOM, he see everything!! Data Sources of two forms are the same = BOM What's wrong for you? Thanks, Anil Ozay Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development

[development-axapta] A question from Axapta Programming Exammmm

to Tools/Development Options/Application Objects/ RefreshData e. Synchronizing the database I know (a) is true. And i think another answer is (b) but i'm not sure!! Does anybody knows it?? Anil Ozay Axapta Technical Consultant DataSistem Genel Otomasyon ve San. Tic.A.S +90 232 4631663 - 208

RE: [development-axapta] A question from Axapta Programming Exammmm

Thanks for all replies :)) Anil Ozay Axapta Technical Consultant DataSistem Genel Otomasyon ve San. Tic.A.S +90 232 4631663 - 208 From: Andrae, Tobias [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 10:47 AM To: [EMAIL PROTECTED] Subject: AW

RE: [development-axapta] How to show container content in the grid

(2); i hope it helps you.. Anil Ozay Axapta Technical Consultant DataSistem Genel Otomasyon ve San. Tic.A.S +90 232 4631663 - 208 From: Baran Sasmaz [mailto:[EMAIL PROTECTED] Sent: Thursday, August 26, 2004 12:00 PM To: [EMAIL PROTECTED] Subject

[development-axapta] Storing Query History

Hi all.. I want to store queries on database... Because user can add new datasources to standart query and add new ranges. After user must save this values, u can access this values on the future.. i want to store query history.. Do you have any idea?? Thanks.. Anýl Özay ERP Technical

RE: [development-axapta] element and this

Hi, i can explain it on a sample. if u override a clicked method of a button on form: this refers to button object. element refers to form object. this refers to only scope you are in, but element refers to whole object (form, report..).in this example, u must use element to call form

RE: [development-axapta] Finding User Group of a user

Hi brahim, U can find groups of users in UserGroupList table.. Location is : System Documentation / Tables / UserGroupList Regards, Anl zay ERP Technical Consultant(Microsoft Axapta) DataSistem Genel Otomasyon ve Sanayi Tic. A.. Web : www.datasistem.com.tr Phone : (0232)

RE: [development-axapta] Decimals in Axapta

Yes, Axapta use 2 decimals.. And you can't change this, if u only change EDT. Because many methods converts decimals to 2 digits with code, statically!! For ex, PriceDisc.Price() calls Currency::price(..) and this calls : currency.pricetypearound(..) and if u can browse the code on

RE: [development-axapta] Wrong type in field number?

().record().tableId; Address.AddrRecId = element.args().record().recId; } } } if element.args.record() is null, this method throws exception.. because null record shouldn't have a table id.. Regards, Anil Ozay _ From: Vaibhav Pednekar [mailto:[EMAIL PROTECTED] Sent

RE: [development-axapta] Send parameter to display method

Hi Baran, Ý can't understand your problem correctly but grid's mouseEnter method may helps you. You can define a global variable, before super() of this method, you can set the varible.. on display() method, you can access this variable.. I wish this helps you.. Regards, Anil

[development-axapta] Accessing Excel from code

Hi all.. When i import invent table records from excel through Data Import/Export i can't view my data from InventTable Form. But i can view it from table browser. So i can decide to access excel spreadsheet from code, and insert to invent table from code. How can i do this? Thanks..

RE: [development-axapta] Accessing Excel from code

Anil Ozay [EMAIL PROTECTED] wrote: Hi all.. When i import invent table records from excel through Data Import/Export i can't view my data from InventTable Form. But i can view it from table browser. So i can decide to access excel spreadsheet from code, and insert to invent table from code

RE: [development-axapta] Relation with LedgerJournalTrans and LedgerTrans

a minimum of 2 Ledgertrans records - one debit, one credit. S _ From: Anil Ozay [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 May 2004 11:18 PM To: [EMAIL PROTECTED] Subject: [development-axapta] Relation with LedgerJournalTrans and LedgerTrans Hi all.. Do you know what is the relation

RE: [development-axapta] SQL error when log into Axapta - Invalid Object Name 'SQLSYSTEMVARIABLES'

Hi.. This problem generally occurs when sql server system rights changed. For ex, if you use bmssa user to connect to sql server, and if owner of many tables in AXDB is dmo, you can't select records. So this message occurs. You should change the owners of tables. Regards Anil

RE: [development-axapta] SQL error when log into Axapta - Invalid Object Name 'SQLSYSTEMVARIABLES'

Thanks Amit, I think the last choise for me but i will add new field LineNum to LedgerTrans. Because voucher and transdate is not enough for me. Anil Ozay _ From: Amit Jain [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 12:15 PM To: [EMAIL PROTECTED] Subject: RE

[development-axapta] Relation with LedgerJournalTrans and LedgerTrans

Hi all.. Do you know what is the relation with LedgerJournalTrans and LedgerTrans? I want to catch LedgerTrans record from LedgerJournalTrans, but i can't find 1-1 relation. Thanks... Anil Ozay [Non-text portions of this message have been removed] Yahoo! Groups Sponsor

YNT: [development-axapta] SP 2 and SP 3

is continued to SP2. Configue your client to SP2 and SP3 with different databases. Regards, Anil Ozay -zgn leti- Kimden: Harry Deshpande [mailto:[EMAIL PROTECTED] Gnderilmi: Sal 18.05.2004 23:43 Kime: [EMAIL PROTECTED] Bilgi: Konu: [development-axapta] SP 2 and SP 3

[development-axapta] Application objects

Hi all. When i right click VendTrans table, and click Add-Ins/Application objects all fields are shown empty. Is this strange??? Anil Ozay [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups

RE: [development-axapta] Re: Inserting data into a table

?,) == DialogButton::No) { CustTable_ds.delete(); // delete current record from data source } } } Regards, Anil Ozay Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL

RE: [development-axapta] Windows Temp Path in Visual Basic

, Anil Ozay From: Mikael Dalgrd [mailto:[EMAIL PROTECTED] Sent: Friday, April 02, 2004 11:11 AM To: [EMAIL PROTECTED] Subject: [development-axapta] Windows Temp Path in Visual Basic Hi there Can anybody tell me how to get the Windowstemp pathin a Visual Basic Code

RE: [development-axapta] Email SysMailer error

Hi, got this error three days ago.. I didnt register Dundas mailer manually, i think it was registered when you installed Axapta. So that, i think you dont have to register it. Maybe u miss to configure SMTP server, beacuse i missed it. When i configured, it worked successfully.

RE: [development-axapta] AX SP2 database error..

, ROUTINES, PARAMETERS, ROUTINE_COLUMNS) Commit Transaction exec sp_configure 'allow updates', 0 reconfigure WITH OVERRIDE -Original Message- From: Anil Ozay [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 24, 2004 9:26 AM To: [EMAIL PROTECTED] Subject: RE: [development

RE: [development-axapta] AX SP2 database error..

Thanks for all replies.. I checked user rights on SQL Server, owner of the views is the same owner of the tables. But i cant find any solution. I use a clear solution, i reinstall the Axapta. No matters now.. Regards, Anil Ozay From: ax [mailto:[EMAIL PROTECTED

RE: [development-axapta] Regarding Forms

reference from element.args.caller() !! Regards, Anil Ozay From: Mikael Dalgrd [mailto:[EMAIL PROTECTED] Sent: Monday, March 08, 2004 11:34 AM To: [EMAIL PROTECTED] Subject: [development-axapta] Regarding Forms Hi there Does anybody have an example on how to handle

[development-axapta] Strange problem.. Form modifications are lost..

this?? Anil Ozay Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [development-axapta] Re: sending of emails without using outlook

I think, the best way is creating your own COM component. This is easy on VB 6.0. If you want to avoid all concerns, dont use third party solutions, use your own. Regards Anil Ozay From: Deshpande, Harry [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 10:43

RE: [development-axapta] Sorting All Data In Look Up Window

(sorted) { _tablelookup.addSortField(_fieldId); // this dont add lookup field, only makes sorting ;) } _tableLookup.parmQuery(_query); return _tableLookup; } Best regards, Anil Ozay From: Michael Jackson [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 4:19 PM

RE: [development-axapta] Sales Order - Simple mode

Hi gigi, You can look Forms/SalesTable/Methods/toggelSimpleAdvanced(...) all initialization about simple-advanced occurs in tihs method. Also if youwant toadd "only" some fields from advanced, drag and drop to related sections of :

RE: [development-axapta] Is there any Numeric To Words function ?

Title: Is there any Numeric To Words function ? Hi Arief, you can use Global::NumeralsToTxt(...) method.. Sample : Global::NumeralsToTxt(round(125000,1.0), CompanyInfo::standardCurrency())); Anil Ozay From: Arief Tarmizi [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 1

[development-axapta] Purchase digit problem..

all calculated fields (purchTotal, purchQty..) comes from AmountCur and it has two digits, so ican't change it to five digits. If i define a new EDT comes from AmountCur, i must change a lot of fields extension types, it may result to incompatable system. How can i solve this problem?? Anil Ozay

[development-axapta] Thanks..

Thanks Sergey.. That's true.. Anil Ozay Yahoo! Groups Sponsor -~-- Upgrade to 128-Bit SSL Security! http://us.click.yahoo.com/p7cEmB/s7qGAA/yigFAA/saFolB/TM -~- Your use of Yahoo

RE: [development-axapta] Selecting data with fieldId..

Thanks Bjrn ;) This is usefully for me.. Regards, Anil Ozay -Original Message- From: Bjrn Gudbrand Idstad [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 12:25 PM To: [EMAIL PROTECTED] Subject: RE: [development-axapta] Selecting data with fieldId.. Hi! Yoy can do something

RE: [development-axapta] Interesting Axapta Error..

:( Do you know why this message created from system? Thanks, Anil Ozay -Original Message- From: Mister L [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 6:15 PM To: [EMAIL PROTECTED] Subject: AW: [development-axapta] Interesting Axapta Error.. This will surely be a system

[development-axapta] xSysLastValue.GetLast() and xSysLastValue.SaveLast()

() method is called. I want to get this values from outside, but i couldn't. Because i couldn't find where this values are saved!! How can i find balanceFromDate, balanceToDate, balanceFiscalYear values of LedgerTable form?? Thanks and regards.. Anil Ozay Yahoo! Groups Sponsor

[development-axapta] Current currency code!!

Hi all.. Does anybody know, how can i find current selected currrency code? (It's on status bar..) Best Regards, Anil Ozay Yahoo! Groups Sponsor ADVERTISEMENT click here Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] Element.pagesTotal returns zero..

Hi all.. Element.Page is working but Element.PagesTotal is returning zero everytime in reports.. How can i solve this problem? Thanks all.. Anil Yahoo! Groups Sponsor ADVERTISEMENT click here _ Yahoo! Groups Links * To visit your group on the web, go to:

RE: RE : [development-axapta] Element.pagesTotal returns zero..

I think, this is the answer of my question :) Thanks, Anil Ozay _ From: Joannick Bacon [mailto:[EMAIL PROTECTED] Sent: Friday, December 19, 2003 3:26 PM To: [EMAIL PROTECTED] Subject: RE : [development-axapta] Element.pagesTotal returns zero.. As it's written in message #4853

RE: [development-axapta] PriceType Enum is crashing!!!

Hi Jacob, I try your advice but it still continue to crash! It is enough to delete this enum, but i couldn't it.. Thanks.. Anil _ From: Jacob Christian Dskeland [mailto:[EMAIL PROTECTED] Sent: Monday, December 22, 2003 3:26 PM To: [EMAIL PROTECTED] Subject: Re:

[development-axapta] Can i use sql on QueryBuildDataSource..

Hi all developers.. I can add range to queryBuildDataSource but my requirements is different, i must use sql. Is there any way to run sql statement on a queryBuildDataSource? All answers are valuable.. Regards.. Anil Ozay. _ Yahoo! Groups Links * To visit your group on the web, go

RE: [development-axapta] executing sql strings

Hi Volkan.. You can use Connection and SqlStatement objects for your requirements.. Sample : Connection Con = new Connection(); Statement Stmt = Con.createStatement(); ResultSet R = Stmt.executeQuery('Any Statement'); while ( R.next() ) { print R.getString(1); // get