RE: [development-axapta] ENUM Element

2006-04-26 Thread Mayle, Michael



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

2006-04-26 Thread Max Belugin
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

2006-04-26 Thread Lennart Conrad



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

2006-04-26 Thread alex_of_at



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

2006-04-26 Thread Agus Riyadi



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

2006-04-26 Thread James Flavell



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

2006-04-26 Thread hany abodoma



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

2006-04-26 Thread Bruno Max Sørensen



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

2006-04-26 Thread Stefan Lundquist (Priv)



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

2006-04-26 Thread eya_parungao



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

2006-04-26 Thread Agus Riyadi



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

2006-04-26 Thread Satish



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

2006-04-26 Thread hemamalinis



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

2006-04-26 Thread V G



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.