Re: [development-axapta] Re: How to access enum values in loop

2004-01-02 Thread jesper . joergensen
Hi,

try this.

   int counter;
   SysDictEnum SysDictEnum;;
   SysDictEnum = new SysDictEnum(EnumNum(ABC));
   for (counter =  0;
counter = enumcnt(ABC)-1;
counter++)
   {
   info(SysDictEnum.index2Label(counter));
   }
Mit freundlichen Gren / Best regards / Med venlig Hilsen

Jesper Jrgensen

Original Message  
processed by Tobit InfoCenter 
Subject: 
[development-axapta] Re: How to access enum values in loop (15-Sep-2003 11:32)	
From:
[EMAIL PROTECTED]	
To:  
[EMAIL PROTECTED]	

Hi,
Thanks for quick reply
But this is not my problem.
say that there is enum TestEnum1 with 4 elements A,B,C 
and D. I want to print A,B,C and D...
I want to do this using a for loop with counter i...
How to get the element of enum TestEnum1 at position i, 
programmatically and print it
Thanks,
Prabodh Kelkar



--- In [EMAIL PROTECTED], Harry [EMAIL PROTECTED] wrote:
hi

int i = 0;

while (i= enumcnt(nameofenum))
{
  i is the value of enum, do something with i.
  i++
}
will work as long as the useenumvalues property of the enum is set 
to true
regards

harry deshpande

-Original Message-
From: prabodh_kelkar [mailto:[EMAIL PROTECTED]
Sent: Monday, 15 September 2003 9:08 p.m.
To: [EMAIL PROTECTED]
Subject: [development-axapta] How to access enum values in loop
Hi,
I want to use the values of enum in loop. 
I want to use the counter of the loop to navigate through the 
elements/values of an enum. i.e. I want to get next value of enum 
as 
loop navigates..How to do that?
Help will be highly appreciated
Thanks,
Prabodh Kelkar


 

Your use of Yahoo! Groups is subject to 
http://docs.yahoo.com/info/terms/



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 



Yahoo! Groups Sponsor	 
ADVERTISEMENT
click here	
	

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 


Re: [development-axapta] SQL Trace

2004-01-02 Thread jesper . joergensen
? Is a wildcard to give the SQL server the option of using the SQL optimizer? 

To debug a problem try using the Axapta debugger

Mit freundlichen Gren / Best regards / Med venlig Hilsen

Jesper Jrgensen
Consulting
mailto: [EMAIL PROTECTED]

Aston Business Solutions GmbH
Kettelerstr. 3-11
D-97222 Wrzburg-Rimpar
Germany 
Tel.   +49-9365-8075-0
Fax   +49-9365-8075-300

http://www.astongroup.de 
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.



Original Message  
processed by Tobit InfoCenter 
Subject: 
[development-axapta] SQL Trace (15-Okt-2003 22:24)	
From:
[EMAIL PROTECTED]	
To:  
[EMAIL PROTECTED]	

Why does my Insert SQL Trace show up with (?,?,?, ...) values when I
know it's inserting other (real) values.
SQL statement: (LBAScaleTable) INSERT INTO LBASCALETABLE
(SCALEID,SCALEDATE,VENDACCOUNT,ITEMID,INVENTLOCATIONID,PURCHID,COMMENT_,
COMMENTCHECKING,COMMENTGRADE,STICKERED,ANCHORSEAL,STANDARDDET,REFNO,VEND
ACCOUNTORIGINAL,STATUS,WMSLOCATIONID,UNIT,CHARACTERISTICSID,BUNDLE,UNLOA
DEDBY,ESTIMATEDBY,INVENTBATCHID,INVOICEDQTY,JOURNALID,TICKNESS,DIVIDER,C
OMPLETED,MODIFIEDDATE,MODIFIEDTIME,MODIFIEDBY,CREATEDDATE,CREATEDTIME,CR
EATEDBY,DATAAREAID,RECID) VALUES
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
[ID=35, Reused=No]
Try debugging a problem when the SQL Trace won't even work...  grrr...

Steeve...

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 



Yahoo! Groups Sponsor	 
ADVERTISEMENT
Click Here!	
	

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 


Re: [development-axapta] Adjustment

2004-01-02 Thread jesper . joergensen
Hi,

You normaly needs to change the EDT to change the field properties. Try having a look at the sysDict* classes and the systemclasses dict*.

You might find a usefull hint in the forms for setting up global types.

/Jesper



Original Message  
processed by Tobit InfoCenter 
Subject: 
[development-axapta] Adjustment (28-Okt-2003 16:12)	
From:
[EMAIL PROTECTED]	
To:  
[EMAIL PROTECTED]	

Hi all,

I wonder if it is possible to adjust a field of a table 
programmatically. I know how to get to the SQLDictionary record for 
the specifick field. It goes something like:

MyTable _table;
int _tableId;
int _fieldId;
;
_tableid = _table.TableId;
_fieldId = fieldName2Id(_tableid,MYCOLUMNNAME);
But after I have that record, what do I need to do to get the 
Adjustment of the field for example to right?

Any help would be appreciated.



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 



Yahoo! Groups Sponsor	 
ADVERTISEMENT
click here	
	

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 


Re: RE : [development-axapta] Adjustment

2004-01-02 Thread jesper . joergensen
Changing the records in the table SQLDictionary NOT a good plan. You might loose date at the next synchronize from Axapta converts the field back the properties as set up in the Axapta AOT. You need to change the EDT in Axapta then synchronize the tables, this will update the SQLDictionary. The SQLDictionary is used by Axapta to support asynchronously update of the Data Dict in Axapta and the SQL Database.

/Jesper



Original Message  
processed by Tobit InfoCenter 
Subject: 
RE : [development-axapta] Adjustment (28-Okt-2003 16:30)	
From:
[EMAIL PROTECTED]	
To:  
[EMAIL PROTECTED]	

I'm not sure, but there's maybe a way to do it.



You could update the rightjustify field of SQLDictionary to true.



tts begin;
SELECT FORUPDATE SQLDictionary
WHERE SQLDictionary.tableId == ?? 

SQLDictionary.FieldId == ?? ;

RightJustify = true;

SQLDictionary.update()

tts commit;



 
Bacon Joannick 
Stagiaire Informatique / IT trainee  
B O A - F R A N C   |   M I R A G E 
T  418.227.1181 #2313
F  418.227.1188 
 
www.boa-franc.com 
 

-Message d'origine-
De : byteway_so [mailto:[EMAIL PROTECTED] 
Envoy : 28 octobre, 2003 10:08
 : [EMAIL PROTECTED]
Objet : [development-axapta] Adjustment



Hi all,

I wonder if it is possible to adjust a field of a table 
programmatically. I know how to get to the SQLDictionary record for 
the specifick field. It goes something like:

MyTable _table;
int _tableId;
int _fieldId;
;
_tableid = _table.TableId;
_fieldId = fieldName2Id(_tableid,MYCOLUMNNAME);
But after I have that record, what do I need to do to get the 
Adjustment of the field for example to right?

Any help would be appreciated.





Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 





Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 



Yahoo! Groups Sponsor	 
ADVERTISEMENT
click here	
	

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 


Re: [development-axapta] How to create UK BACS file format?

2004-01-02 Thread jesper . joergensen
hi,

try this

public class VendOutPaym_UKBACS extends VendOutpaym

/Jesper



Original Message  
processed by Tobit InfoCenter 
Subject: 
[development-axapta] How to create UK BACS file format? (28-Okt-2003 11:36)	
From:
[EMAIL PROTECTED]	
To:  
[EMAIL PROTECTED]	

Hi,

How can I create a file format for UK BACS payment?  I am able to 
only select available formats, but there is no place where I can add 
new format.  I am using Axapta ver 3.0/SP2.

Thanks in advance.

Harish



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 



To: [EMAIL PROTECTED]
   [EMAIL PROTECTED]
Yahoo! Groups Sponsor	 
ADVERTISEMENT
click here	
	

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 


Re: [development-axapta] Intercompany trading

2004-01-02 Thread jesper . joergensen
Hi,

have you set up Possible actions as well? 

You need to setup accountnumber, itemnumber, etc. to use in the transfer.

Mit freundlichen Gren / Best regards / Med venlig Hilsen

Jesper Jrgensen
Consulting
mailto: [EMAIL PROTECTED]

Aston Business Solutions GmbH
Kettelerstr. 3-11
D-97222 Wrzburg-Rimpar
Germany 
Tel.   +49-9365-8075-0
Fax   +49-9365-8075-300

http://www.astongroup.de 
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.



Original Message  
processed by Tobit InfoCenter 
Subject: 
[development-axapta] Intercompany trading (10-Nov-2003 10:52)	
From:
[EMAIL PROTECTED]	
To:  
[EMAIL PROTECTED]	

Hi all,

I am setting up intercompany trading between 2 companies.
I have setup organization and org references.
When i started to create a PO using the related vendor / customer, i 
get this error message:

Conversion of Customer / vendor code was not specified.

I have checked all setup, and nothing seems to be wrong.
Anyone has any idea?
I am on Version 3.0 SP2.

thanks,
ag


Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 



Yahoo! Groups Sponsor	 
ADVERTISEMENT
click here	
	

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 


Re: [development-axapta] change of tableID

2004-01-02 Thread jesper . joergensen
Hi,

yes, but only on your new tables not on the Sys..Lop Tables. 

You need to export your tables with ID from the version 2.5.

Then thange the ID in the xpo to the next free number.

Before you deploy to the customer you need to change the table ID for the tables in the Table SQLDICTIONARY, otherwise Axapta will drop the table and create it again with a new TableID.

Have fun. -)

Jesper



Original Message  
processed by Tobit InfoCenter 
Subject: 
[development-axapta] change of tableID (01-Dez-2003 10:12)	
From:
[EMAIL PROTECTED]	
To:  
[EMAIL PROTECTED]	

HI, is there a way to change tableid in axapta 30?

Problem:
I am upgrading from 2.5 to 3.0 and sertain tables have changed 
tableid.

regards
Per Christian 



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 



Yahoo! Groups Sponsor	 
	 
	

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 


Re: [development-axapta] Dataupgrade v2.5 - v3.0

2004-01-02 Thread jesper . joergensen
HI,

Yes. 

In the class ReleaseUpdateDBV25toV30 create a new methode that loops over yout tables (sysdicttable) and the fields (sysDictField). Then select the record in SysDictionary that matchese the name and update this with the new TableId. Do not forget to update the TableId on the fields as well. After that recreate all indexes, as the index is prefixed the TableId.

in the method initJob create new Job as addStartJob.

And you are done.

regards

Jesper



Original Message  
processed by Tobit InfoCenter 
Subject: 
[development-axapta] Dataupgrade v2.5 - v3.0 (01-Dez-2003 12:52)	
From:
[EMAIL PROTECTED]	
To:  
[EMAIL PROTECTED]	

Hi!

I have a problem with dataupgrade from 2.5 to 3.0.
The problem is that many of my tables have different tableID. 

Does anyone know if and where i can override the code when upgrading 
the data. So that I can map tablename instead of tableId?

regards
Per Christian


Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 



Yahoo! Groups Sponsor	 
ADVERTISEMENT
click here	
	

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 


Re-2: [development-axapta] client /server connection

2004-01-02 Thread jesper . joergensen
The recommendations from Microsoft are by 50 ms, and a minimum of 100ms. Check out the TechNet for information on latency and hardware sizing.



/Jesper



Original Message  
processed by Tobit InfoCenter 
Subject: 
RE: [development-axapta] client /server connection (05-Dez-2003 11:00)	
From:
[EMAIL PROTECTED]	
To:  
[EMAIL PROTECTED]	

You should decrease the latency, 180 ms or less.

Best regards 

Artem Tymofyeyev 
Axapta Technology Domain 

Microsoft Business Solutions 
Navision 
Frydenlunds All 6, DK-2950 Vedbaek 
http://www.microsoft..com/BusinessSolutions

-Original Message-
From: userm1837 [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 03, 2003 20:43
To: [EMAIL PROTECTED]
Subject: [development-axapta] client /server connection

Hi,

I run performance test on a PC because Axapta is running slow.  The 
latency was too big. (1129.70 milliseconds).  How can one improve the 
performance.

Thanks





Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ 





Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 



Yahoo! Groups Sponsor	 
ADVERTISEMENT
click here	
	

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 


Re: [development-axapta] creating and writing a file

2004-01-02 Thread jesper . joergensen
Try the Classes ASCIIIO, CommaIO, or comma7IO. You will find the documentation in the system documentation.

/Jesper



Original Message  
processed by Tobit InfoCenter 
Subject: 
[development-axapta] creating and writing a file (11-Dez-2003 11:07)	
From:
[EMAIL PROTECTED]	
To:  
[EMAIL PROTECTED]	

Hi all...

I want to create and write a txt file through axapta but I cant find 
any function about this.
How can I do this? or can I do this with using axapta?
thanks your advise... 



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 



Yahoo! Groups Sponsor	 
	 
	

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 


Re: [development-axapta] enum2str() .. language labels

2004-01-02 Thread jesper . joergensen
Hi Jan,



I don't know if this is he best way, but it works.



static void JJ_Test(Args _args)

{

   LanguageId  orglanguageId = infolog.language();

   ;

   infolog.language('En-GB');

   info(enum2str(ItemType::Service));

   infolog.language('FI');

   info(enum2str(ItemType::Service));

   infolog.language(orglanguageId);

}



/Jesper

Original Message  
processed by Tobit InfoCenter 
Subject: 
[development-axapta] enum2str() .. language labels (10-Dez-2003 9:50)	
From:
[EMAIL PROTECTED]	
To:  
[EMAIL PROTECTED]	

Hello,

enum2str(CustInvoiceJour.SalesType)

returns the English string value (label) for the enum element.
How do I get the other languages texts?
Jan



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 



Yahoo! Groups Sponsor	 
ADVERTISEMENT
click here	
	

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.