RE: [development-axapta] ENUM Element
Mike, I just tried this one... static void Job590(Args _args) { int x; ; x = salesStatus::Canceled; box::info(int2str(x)); } Not sure if it will work for your application, but there it is. Enjoy, Michael Mayle Disc Makers -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Savage Sent: Monday, April 24, 2006 7:52 AM To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] ENUM Element Thanks Yavuz I was thinking more of how do I do it from within a class, for example. In the class I would have LedgerAccountType::AccountRevenue, but how, from there, do I determine the element id via a function? Cheers Mike Savage Sense Enterprise Solutions Ltd -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Yavuz YILDIZ Sent: 24 April 2006 12:25 To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] ENUM Element Login to Axapta as Administrator and open AOT. Select Data Dictionary\Base Enums. You can see that enum values. --- Mike Savage [EMAIL PROTECTED] wrote: Hi. How do I determine which element of an enum an enum element is in code?! I.e. LedgerAccountType::AccountRevenue = ?? Enum2Value seems to return the string not the element id!! Cheers Mike Savage Sense Enterprise Solutions Ltd [Non-text portions of this message have been removed] Yavuz YILDIZ ERP Developer Star Group Glass Processing __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Yahoo! Groups Links Yahoo! Groups Links SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. 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] ENUM Element
24.04.06 в 15:52 Mike Savage в своём письме писал(а): Thanks Yavuz I was thinking more of how do I do it from within a class, for example. In the class I would have LedgerAccountType::AccountRevenue, but how, from there, do I determine the element id via a function? info(strFmt('%1', any2int(LedgerAccountType::AccountRevenue))); int a=LedgerAccountType::AccountActive; ; info(strFmt('%1', a)); --- http://axcoder.blogspot.com 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: http://docs.yahoo.com/info/terms/
RE: [development-axapta] Optimistic Concurrency Checking/RecVersion
The field is related to the OCC. Everytime the record is updated the recversion is changed. So the kernel checks if the recversion you try to commit is different than the one in the database - if it is, somebody else updated the record before you and your update fails. Regards Lennart -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of cdlmalherbe01 Sent: 18. april 2006 08:48 To: development-axapta@yahoogroups.com Subject: [development-axapta] Optimistic Concurrency Checking/RecVersion Hi all, I'm trying to come to grips with differences between Ax3/4 and SQL2000/2005. A feature that was introduced with Ax3 KR1/Sp5 is optomistic concurrency checking. I'd like to know if the addition of a column called RECVERSION to each table has anything to do with OCC? Regards, Christoph Yahoo! Groups Links YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Re: ENUM Element
Mike, just use int2str. Enum are represented internally as integers. Try: info(strfmt(No is %1, Yes is %2, int2str(NoYes::No), int2str(NoYes::Yes))); and you'll get: No is 0, Yes is 1 Pls be careful not to litter your code by using explicit integer constants. As a rule you should only use the defined literals. Have a nice day Alex --- In development-axapta@yahoogroups.com, Mike Savage [EMAIL PROTECTED] wrote: Thanks Yavuz I was thinking more of how do I do it from within a class, for example. In the class I would have LedgerAccountType::AccountRevenue, but how, from there, do I determine the element id via a function? Cheers Mike Savage Sense Enterprise Solutions Ltd -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Yavuz YILDIZ Sent: 24 April 2006 12:25 To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] ENUM Element Login to Axapta as Administrator and open AOT. Select Data Dictionary\Base Enums. You can see that enum values. --- Mike Savage [EMAIL PROTECTED] wrote: Hi. How do I determine which element of an enum an enum element is in code?! I.e. LedgerAccountType::AccountRevenue = ?? Enum2Value seems to return the string not the element id!! Cheers Mike Savage Sense Enterprise Solutions Ltd [Non-text portions of this message have been removed] Yavuz YILDIZ ERP Developer Star Group Glass Processing __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Yahoo! Groups Links YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. 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] ENUM Element
Hi Mike You can get the enumid with enumnum function. If you want to get enum element value then assign it to an integer type then you get the number. Regards, Agus On 4/24/06, Mike Savage [EMAIL PROTECTED] wrote: Thanks Yavuz I was thinking more of how do I do it from within a class, for example. In the class I would have LedgerAccountType::AccountRevenue, but how, from there, do I determine the element id via a function? Cheers Mike Savage Sense Enterprise Solutions Ltd -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Yavuz YILDIZ Sent: 24 April 2006 12:25 To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] ENUM Element Login to Axapta as Administrator and open AOT. Select Data Dictionary\Base Enums. You can see that enum values. --- Mike Savage [EMAIL PROTECTED] wrote: Hi. How do I determine which element of an enum an enum element is in code?! I.e. LedgerAccountType::AccountRevenue = ?? Enum2Value seems to return the string not the element id!! Cheers Mike Savage Sense Enterprise Solutions Ltd [Non-text portions of this message have been removed] Yavuz YILDIZ ERP Developer Star Group Glass Processing __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Yahoo! Groups Links Yahoo! Groups Links [Non-text portions of this message have been removed] YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. 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] Business Views
Hi Mike, Yeah I am not too sure...I am guessing it was an early attempt at using Axapta as some kind of BI tool as you have things like grouping but it is very limited and I get the feeling they did it and then left it because it was not worth anymore effort due to better tools being out there in the BI market Anyway I am interested to know a little more on a somewhat related issue: Is it possible to have a report that prints data from all companies? By default the kernel (I think) fitlers it to the current company so even if I cahnge the property 'Company' in the datasource it will only ever take it from the active company!!! If there any way to avoid this behavior inside datasources/queries? So far the only possible way I have come across is by using business views but these are not able to be used inside Axapta (because they basically create SQL objects) Thanks James -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Savage Sent: 22 April 2006 00:43 To: development-axapta@yahoogroups.com Subject: [development-axapta] Business Views Does anyone know what the purpose and use of the 'Business views' functionality is in the Admin module? According to the help text '_dictTable.name() != 'In the Business Views form you create new business views allowing data from the database to be wrapped and translated into human readable format.' I can create a view in the form in Axapta and see it in the Views section of Enterprise Manager, but now what? I could use another tool to look at it I suppose, but how can I access it from Axapta? Cheers Mike Savage Sense Enterprise Solutions Ltd Corner House Robey Close Linby Nottinghamshire NG15 8AA t: +44 (0) 115 964 6646 f: +44 (0) 115 964 6647 e: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] w: www.senseenterprisesolutions.co.uk Confidentiality: This e-mail and its attachments are intended for the above named only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to this e-mail and highlight the error. Security Warning: Please note that this e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium. We advise that you understand and observe this lack of security when e-mailing us. Viruses: Although we have taken steps to ensure that this e-mail and attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure they are actually virus free. [Non-text portions of this message have been removed] SPONSORED LINKS Computer http://groups.yahoo.com/gads?t=msk=Computer+partw1=Computer+partw2=Progr amming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=yLpvc LTIDJ5FTkRJGsO11w part Programming http://groups.yahoo.com/gads?t=msk=Programming+languagesw1=Computer+part w2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.s ig=cuhEClK4dU4wapXFmKisbQ languages Microsoft http://groups.yahoo.com/gads?t=msk=Microsoft+axaptaw1=Computer+partw2=Pr ogramming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=yf eG_U6QaLfPOZZIud02Fg axapta Support http://groups.yahoo.com/gads?t=msk=Support+exchangew1=Computer+partw2=Pr ogramming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=hy 8yRGMzrmxdphyITTUeqA exchange _ YAHOO! GROUPS LINKS * Visit your group development-axapta http://groups.yahoo.com/group/development-axapta on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . _ [Non-text portions of this message have been removed] YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. 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] Accessing of remotely registered DLL from Axapta
Dear you can use Tools - development Tools - Wizerd - ComClass Wrapper Wizerd then you can regester your Dll and ypu can use the configuration utility and register the DLL Amar Senapati [EMAIL PROTECTED] wrote: Hi All, I am using the COM class to access remotely registered DLL. But it throws me an error saying COM object of class 'My DLL'could not be created.Ensure that the object has been properly registered on Comuter MYCOMPUTER MYCOMPUTER is my local computer name and i am running the axapta client. I have registered the 'MyDLL' dll on a remotely computer where my Axapta application and database exists. If i register the DLL on my local machine , it works fine. Can anyone point me , what i am missing to access the remotely registered DLL. Here is the code : COM _com,; ; _com = new COM('MyDLL'); Thanks in Advance Amar __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange - YAHOO! GROUPS LINKS Visit your group development-axapta on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1cent;/min. [Non-text portions of this message have been removed] YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. 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] Export record to text file
Hi Irwan io.write(buf2con(table)) _ From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Irwan Mulia Sent: 22. marts 2006 02:58 To: development-axapta@yahoogroups.com Subject: [development-axapta] Export record to text file Hi, How do we export record into text file ? Supposed I have table A; with 3 fields : field1,field2,field3 and I want to export with format : - field1,field2,filed3 field1,field2,filed3 ... - TIA Irwan [Non-text portions of this message have been removed] _ YAHOO! GROUPS LINKS * Visit your group development-axapta http://groups.yahoo.com/group/development-axapta on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . _ [Non-text portions of this message have been removed] SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
SV: [development-axapta] ENUM Element
Hi One way of doing it is: int i; i = LedgerAccountType::AccountRevenue; print i; This gives you the enum value. Is that what you are looking for ? /Stefan -Ursprungligt meddelande- Fran: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Mike Savage Skickat: den 24 april 2006 13:52 Till: development-axapta@yahoogroups.com Amne: RE: [development-axapta] ENUM Element Thanks Yavuz I was thinking more of how do I do it from within a class, for example. In the class I would have LedgerAccountType::AccountRevenue, but how, from there, do I determine the element id via a function? Cheers Mike Savage Sense Enterprise Solutions Ltd -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Yavuz YILDIZ Sent: 24 April 2006 12:25 To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] ENUM Element Login to Axapta as Administrator and open AOT. Select Data Dictionary\Base Enums. You can see that enum values. --- Mike Savage [EMAIL PROTECTED] wrote: Hi. How do I determine which element of an enum an enum element is in code?! I.e. LedgerAccountType::AccountRevenue = ?? Enum2Value seems to return the string not the element id!! Cheers Mike Savage Sense Enterprise Solutions Ltd [Non-text portions of this message have been removed] Yavuz YILDIZ ERP Developer Star Group Glass Processing __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Yahoo! Groups Links Yahoo! Groups Links SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] AxaptaCOMConnector: Getting Existing Tables
Hi everyone! I'm developing in C# and we need to connect to Axapta. I'm new with using the AxaptaCOMConnector.. Is there anyone who knows how I could get the list of all existing tables in the Axapta database using this? I would really appreciate your help. God bless! SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. 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] Export record to text file
Hi Irwan, Take a loot at the CommaIo class documentation in AOT. Regards, Agus On 3/22/06, Irwan Mulia [EMAIL PROTECTED] wrote: Hi, How do we export record into text file ? Supposed I have table A; with 3 fields : field1,field2,field3 and I want to export with format : - field1,field2,filed3 field1,field2,filed3 ... - TIA Irwan [Non-text portions of this message have been removed] Yahoo! Groups Links [Non-text portions of this message have been removed] SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Urgent: Working with lookups in a form
Hi guys, I've created a form. The form is linked to a Header_Table and a Detail_Table. Now, i try to let the user select a field(which is the primary key) from the Header_Table using a lookup in my form. Based on the value of this primary key, i try to display the contents of the Header_Table in the form's header section, and the contents of the DetailTable in a grid. I'm really stuck on 2 counts... 1) Creating and using lookups in Axapta. 2) Pulling data from SQL based on the value input by the user. If i create lookups using the foreign key relationship in a table, then the value selected from the lookup is not stored in the new table upon closing the form. Also, once selected, the other related fields dont refresh. I'm new to Axapta, so my query may seem a bit silly... But, i'm really stuck with this one :( I would appreciate a little detailed solution... a bit of sample code would be wonderful :) Thanx in anticipation. Regards, Satish YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] creating password field
Hi, how do i create password field? ie. when the user types value, it should be displayed as astriks characters (). then i want to store it as string value and when retrieving value, then the corresponding value should be displayed as . pls. provide the solution. thank u. regs, Hema. S YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] How to find the data type of the field
Hello Can anyone help me find the datatype of the field if I have table Id and FieldId. Thanks VG [Non-text portions of this message have been removed] YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.