RE: [development-axapta] RE: Database size vs Size of company accounts

2004-11-17 Thread Holger K. Pedersen
The total is wrong. Try to sum up the size in bytes , and the result is more than 54 Gb. The report is in err. That's my opinion. From: Matt Benic [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Axapta Dev [EMAIL PROTECTED] Subject: [development-axapta] RE: Database size vs Size of

RE: [development-axapta] Compare Records

2004-11-17 Thread Holger K. Pedersen
Normally, you must compare field by field for all fields in the records. Since records differs for each table, there is no easy way to do it. Unless, all your tables has a CRC which could be used for comparison, this would be a daunting task to accomodate for Standard Axapta tables. The

RE: [development-axapta] Reflection on methods of a class

2004-10-06 Thread Holger K. Pedersen
Hi Manfred, By using staticmethodstr(classname,staticmethodname) you can make sure, the static method with name staticmethodname exists in compiled form in the class classname. Concerning the endresult, there will be produced a string of length 40. Do not delve too much into the length,

RE: [development-axapta] refresh of datagrid

2004-09-30 Thread Holger K. Pedersen
Use the element.redraw(); when the change has been made. This way you get the form updated with current datasource values. Holger :o) From: Jesmond Giordimaina [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [development-axapta] refresh of datagrid Date: Wed,

RE: [development-axapta] semicolon

2004-06-04 Thread Holger K. Pedersen
I have noticed, the semicolon issue, when first statement is a call to a static method. I also see this issue as a weird feature of X++. Normally, it is used as a separator, but the compiler obviously has a faulty behavior when it tries to figure out what is variable decalaration, and whait

RE: [development-axapta] Modify createdBy field

2004-06-04 Thread Holger K. Pedersen
Czesc Tomasz My best guess is, overwriteSystemfields() is an overseen method. I don't think it works. System fields may not be inserted or updated. It might be just a teaser for someone like a developer ;-) What is the consequence of changing the name of the creator, or the Creation Time

RE: [development-axapta] XML problems

2004-05-25 Thread Holger K. Pedersen
One problem is the protocol used. VS.NET schemas are of the standard, W3C XMLSchema, whereas the Commerce Gateway uses xCBL schemas of the older origin, the SOX schema. The newest version of xCBL (version 4.0) has not been implemented into Axapta. You can look into the way Axapta Commerce

RE: [development-axapta] How can I find (Axapta) Tables, who's field(s) contain a given extendedDataType?

2004-05-10 Thread Holger K. Pedersen
Try this. static void FindTablesWithListCodeId(Args _args) { SqlDictionary sqlDictionary; DictTable dt; int i, j; boolean blnFound; ; while select sqlDictionary order by name where sqlDictionary.fieldId==0 sqlDictionary.name like '*' { dt = new DictTable(sqlDictionary.TabId); //

Re: [development-axapta] datetime conversation..

2004-01-02 Thread Holger K. Pedersen
The problem is the use of date2str. In this case, it has nothing to do with the SQL Server conversion. Your problem is because of the following: You need at Date type as first argument to the date2str() function, but you have a str type. use str2date() function to convert to date before you

Re: [development-axapta] How to filter data when lookup?

2004-01-02 Thread Holger K. Pedersen
Hi Amar I think, your expression, iNNSO_SalesOrderGraphPerCust.parmCustAccount() returns a single Customer Account Number. Obviously, that is not what you want. You might be able to get more values, if you build the string of numbers before applying to your range value. like: int i;

RE: [development-axapta] variable in sql statement

2004-01-02 Thread Holger K. Pedersen
void funcWhatever(EmplId _emplId) { EmplTable emplTable; ; while select emplTable where emplTable.EmplId == _emplId { // looping through table info(strfmt(%1,emplTable.EmplId)); } } Try somthing like this. :-) From: Agus Riyadi [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED]

RE: [development-axapta] Re: expression builder

2004-01-02 Thread Holger K. Pedersen
I haven't looked into more detailed generation of X++ code, but perhaps, you can use runbuf() function. Look at the following to get inspiration to build and run X++ code on the fly. static void runbufTest(Args _args) { str myjob = int add3(int i){ return i+3;}; int i; ; for

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

2004-01-02 Thread Holger K. Pedersen
You can use TextBuffer class or BinData class, which are easy to use. static void FileTestJob(Args _args) { TextBuffer tb; BinaryIo bio; BinData bd; tb = new TextBuffer(); tb.setText(some text); print tb.getText(); bd = new BinData(); bd.setStrData(Axapta);

RE: [development-axapta] AOS Port Behind Firewall

2004-01-02 Thread Holger K. Pedersen
Default port means, that the operating system will assign any port available. From: Morten Aasheim [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: [development-axapta] AOS Port Behind Firewall Date: Thu, 11 Dec 2003 13:17:13 +0100 Hi. You can define which

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

2004-01-02 Thread Holger K. Pedersen
[EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [development-axapta] Re: creating and writing a file Date: Thu, 11 Dec 2003 16:05:11 - before thanks your help what shuld I do if I want to write to a new line in the txt file? --- In [EMAIL PROTECTED], Holger K

RE: [development-axapta] Methods while collecting data on grids data source

2004-01-02 Thread Holger K. Pedersen
You can use mod relational operator. select yourTable where yourTable.lastcolumn mod 3 = 0 :-) From: vozadali [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [development-axapta] Methods while collecting data on grids data source Date: Thu, 11 Dec 2003 18:00:05

RE: [development-axapta] try catch with runbuf

2004-01-02 Thread Holger K. Pedersen
It is not meant to be used this way. You are compiling the code in runtime, and the compiler compiles to exactly the number of arguments as given. static void Job6(Args _args) { str s; try { s=runbuf(int myfunc(int i, str s) { print s; return i; }, 5, 126); print s;