Re: [Axapta-Knowledge-Village] Re: Report Is Empty

2005-04-20 Thread Varden Morris
Jesse   Are you sure you are connecting to the same data source that the AOS is using?jesse <[EMAIL PROTECTED]> wrote: Jim,Yes... it's the same company. Regards,Eng Han--- In Axapta-Knowledge-Village@yahoogroups.com, Jim Dickie <[EMAIL PROTECTED]> wrote:> Are you logging in to the same company?>

Re: [Axapta-Knowledge-Village] French labels for the menus

2005-04-20 Thread Varden Morris
Hi Stefan   You will first need to have the license for the language. The labels will then be created automatically by Axapta. You will then have to choose the appropriate language from the language combo of the General tab on the client’s configuration. Varden Morris   J. Wray & Nephew

Re: [Axapta-Knowledge-Village] More Users than license allowed.

2005-04-20 Thread Varden Morris
this problem.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2226Fax:  (876) - 923 - 5372 Cell:  (876) - 3833566Email:   [EMAIL PROTECTED]    [EMAIL PROTECTED]     Craig Fidler <[EMA

Re: [Axapta-Knowledge-Village] Age Analysis report error

2005-04-18 Thread Varden Morris
on the RPM host and verify the level of access permissions. Change the account that the RPM service is running under to a user account. This should be a domain user, however, in the case of Windows 2000/NT, a local user may also be sufficient. Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234

Re: [Fwd: Re: [Axapta-Knowledge-Village] Find Label]

2005-04-18 Thread Varden Morris
Hi Luis   Is there a reason for you not wanting to change the text for this label? If you change the text for the label the new text will appear everywhere the label is used.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone: 

RE: [Axapta-Knowledge-Village] How to get actual time of system... with milliseconds or similar??

2005-04-18 Thread Varden Morris
You are most welcome Raul.Raul Llorente Peña/OPENSOLUTIONS <[EMAIL PROTECTED]> wrote: Thanks for confirming it, guy ;-) Thanks very much for your attention, Varden!! Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS Varden

Re: [Axapta-Knowledge-Village] Session blocked in database when several user posting !

2005-04-15 Thread Varden Morris
, BLOCKED, LOGINAME  FROM master..sysprocesses WHERE blocked <> 0   You may then kill the process that is causing the block in Query Analyzer as follows:   Kill 98   where 98 is the blocking spid.     Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Ja

RE: [Axapta-Knowledge-Village] How to get actual time of system... with milliseconds or similar??

2005-04-15 Thread Varden Morris
ollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS Varden Morris <[EMAIL PROTECTED]> 14/04/2005 13:50 Por favor, responda aAxapta-Knowledge-Village@yahoogroups.com Para Axapta-Knowledge-Village@yahoogroups.com cc Asunto RE: [Axapta-Knowledge-Village] How t

Re: [Axapta-Knowledge-Village] Report is empty

2005-04-15 Thread Varden Morris
a to be printed to the report oryou may use a >programmable section to print the databy calling >element.execute(). >Varden Morris    __ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mailSharing

RE: [Axapta-Knowledge-Village] How to get actual time of system... with milliseconds or similar??

2005-04-14 Thread Varden Morris
GetTickCount() returns an integer that is the number of thousands of seconds that the system has been running and not the time which I think Raul is interested in. Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 -

Re: [Axapta-Knowledge-Village] Report is empty

2005-04-14 Thread Varden Morris
of the programmable section. Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2226Fax:  (876) - 923 - 5372 Cell:  (876) - 3833566Email:   [EMAIL PROTECTED]     [EMAIL PROTECTED]   setiaji kurni

Re: [Axapta-Knowledge-Village] Why sentence try/catch is invisible for COM sessions in 2.5?

2005-04-14 Thread Varden Morris
I have noticed this too Raul and it is still a puzzle up to this point for me. Raul Llorente Peña/OPENSOLUTIONS <[EMAIL PROTECTED]> wrote: In 2.5, sentences blocks try/catch aren't managed by Axapta when session is a COM one.   Let's see this example code (doesn't matter wherever you put it to

Re: RE : [Axapta-Knowledge-Village] COM calling from Fat client

2005-04-09 Thread Varden Morris
connecting simultaneously (remember that 3-tier is scalable unlike 2-tier)? Do you thing of the fact that here is a possibility that your problem may not be solved going 2-tier?     Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) -

RE: [Axapta-Knowledge-Village]

2005-04-07 Thread Varden Morris
think that and what harry had to say about creating a Temp Table and load from there..   Thanks Friend From: Varden Morris [mailto:[EMAIL PROTECTED] Sent: Wednesday, 6 April 2005 2:41 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] Rocco   You can look

RE: [Axapta-Knowledge-Village]

2005-04-05 Thread Varden Morris
Rocco   You can look at the CacheLookup property on the table. It is not recommended to cache tables that are frequently updated but since the inventory table should be fairly static you may consider do this by setting the property appropriately.    Varden Morris   J. Wray & Nephew

Re: [Axapta-Knowledge-Village] AW: SalesId Adjustment

2005-04-05 Thread Varden Morris
.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2226Fax:  (876) - 923 - 5372 Cell:  (876) - 3833566Email:   [EMAIL PROTECTED]    [EMAIL PROTECTED]   "Gahr, Andreas" <[EMAIL

Re: [Axapta-Knowledge-Village] Leap year - reports

2005-04-05 Thread Varden Morris
Hi Charmaine   If the report uses a query you just need to add the date as a range on the query. Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2226Fax:  (876) - 923 - 5372 Cell: 

Re: [Axapta-Knowledge-Village] Re: ODBC

2005-03-31 Thread Varden Morris
Hi Axnbie   You will have to run your report via a class. I did an example for you in a project that I attached. Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2226Fax:  (876) - 923 - 5372

Re: [Axapta-Knowledge-Village] ODBC

2005-03-30 Thread Varden Morris
on the programmable section.     Fetch …..   while (myResult.next()) {Var1 = myResult.getString(1);Var2 = myResult.getString(2); Elment.execute(1);  //execute the programmable section with //ControlNumer property = 1  }   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spa

RE: [Axapta-Knowledge-Village] Reading Real Values from Com-Port

2005-03-30 Thread Varden Morris
Hi Ali   Look as the MSCOMM activeX control. If you look at it from Axapta the name is Microsoft Communication control. To read data on demand you can output the end of line character on the port then the onEvent_OnComm() event will be fired. You can then read the data from there. Varden

Re: [Axapta-Knowledge-Village] Re: Regarding Axapta Installation

2005-03-29 Thread Varden Morris
point to the AOS. It is better to use one XPO configuration file for all the clients since is saves on maintenance.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2226Fax:  (876) - 923 - 5372 Cell: 

RE: [Axapta-Knowledge-Village] URGENT!!!! RecId

2005-03-29 Thread Varden Morris
Hi Chea,   Just execute this command again:   select _tblSales;   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2226Fax:  (876) - 923 - 5372 Cell:  (876) - 3833566Email:   [EMAIL PROTE

Re: [Axapta-Knowledge-Village] cannot edit a record in inventory dimension

2005-03-23 Thread Varden Morris
Hi   In addition to using forUpdate you must eclose the update in a transaction. For example:   ttsbegin;   while select forUpdate CustTable where CustTable.CustGroupID == '10' { CustTable.Balance = 1000; CustTable.Update(); }   ttscommit; Subrahmanyam Mamidi <[EMAIL PROTECTED]> wrote

Re: [Axapta-Knowledge-Village] operation from combination of enum

2005-03-17 Thread Varden Morris
Combo(1, 2):     info(strfmt('%1',UniqueEnumCombo(1, 2)));     break;       }   }     Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2226Fax:  (876) - 923 - 5372 Cell:  (876)

RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0

2005-03-16 Thread Varden Morris
Please remember to filter by DATAAREAID when using the Statemant class.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2226Fax:  (876) - 923 - 5372 Cell:  (876) - 3833566Email:   [EMAIL PROTE

Re: [Axapta-Knowledge-Village] Serial or batch number

2005-03-15 Thread Varden Morris
first thing he may ask you for is the batch number so that he may look back at the production of that batch to see if he can detect the problem. He may also withdraw the entire batch from the market.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica,

Re: [Axapta-Knowledge-Village] How to perform self join in X++

2005-03-14 Thread Varden Morris
Try declaring table buffers with different names as follows:   CustTable   CustTable1; CustTable   CustTable2;   Use CustTable1 and CustTable2 in the query.    Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141

Re: [Axapta-Knowledge-Village] Select where with a filter

2005-03-14 Thread Varden Morris
Hi Padmaja   The correct syntax is as follows:    select LedgerTrans where LedgerTrans.Accountnum >= '1000' &&    LedgerTrans.AccountNUm <= '2000' && LedgerTrans.TransDate == 1\1\2004 &&    LedgerTrans.Voucher like 'F111*';   Varden 

Re: [Axapta-Knowledge-Village] What is a clustor Index?

2005-03-12 Thread Varden Morris
per table and a table that has a clustered index can have several non-clustered indexes.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2226Fax:  (876) - 923 - 5372 Cell:  (876) - 3833566Email:   [E

Re: [Axapta-Knowledge-Village] SalesID Adjustment

2005-03-11 Thread Varden Morris
SalesID EDT will have to be modified. It is best not to do this while other users are working in the system.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2226Fax:  (876) - 923 - 5372 Cell: 

Re: [Axapta-Knowledge-Village] Re: Error with macro

2005-03-11 Thread Varden Morris
I need to make a correction. Macro errors show up at compile time. If you create any macro (macros in macro libraries, stand-alone macros and (local) macros inside methods) and do not use it there is no possibility of getting an error. Macro is a string that may be used as a substitution in cod

RE: [Axapta-Knowledge-Village] What does 'ReIndex" function exactly do

2005-03-11 Thread Varden Morris
ts.   From: Varden Morris [mailto:[EMAIL PROTECTED] Sent: Friday, 11 March 2005 9:14 a.m.To: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] What does 'ReIndex" function exactly do   Hi Padmaja   You are correct, index is use to search a table in a more effic

Re: [Axapta-Knowledge-Village] What does 'ReIndex" function exactly do

2005-03-10 Thread Varden Morris
a personal experience with a table where my Axapta client hangs up each time I tried to update a record in the table. After re-indexing the table the problem went away.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 -

Re: [Axapta-Knowledge-Village] How i can find the sum figures with a specific month and year combo

2005-03-10 Thread Varden Morris
As far as I know Axapta does not allow you to use function calls in the WHERE clause of a select statement. You can get around that by using the select statement syntax of your back end database as follows. I am using Microsoft SQL.   static void SumByYearANDMonth(Args _args){    Connection  con

Re: [Axapta-Knowledge-Village] Hi

2005-03-09 Thread Varden Morris
the data from these tables so that you can use standard Axapta to import the data.   You then need to write code to create journal entries from these tables and then use standard Axapta to post the journals.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingsto

Re: [Axapta-Knowledge-Village] Insert_Recordset with join condition

2005-03-08 Thread Varden Morris
SalesTable.SalesID == 'GX1900'    {    TableForInsert.Field1 = SalesTable.ApprovedBy;    recInserts.add(TableForInsert);    TableForInsert.clear();    }    recInserts.insertDatabase(); Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica

Re: [Axapta-Knowledge-Village] how to minimize blocking on axapta ?

2005-03-08 Thread Varden Morris
rprise.   Before I get the boss to spend more cash on this SQL Upgrade, do you know of any way to get SQL to use 3GB of RAM on the Standard Edition.   ps.  Also any Tips on Table Indexing.   Rocco     From: Varden Morris [mailto:[EMAIL PROTECTED] Sent: Monday, 7 March 2005 7:15 PMTo: Axapta-K

Re: [Axapta-Knowledge-Village] Re: Error with macro

2005-03-07 Thread Varden Morris
Hi Danny,   Macro errors only occur at runtime.Danny Gaethofs <[EMAIL PROTECTED]> wrote: Sorry all for your time, I found the reason for it.It was in the definition of the macro itselve.I created a macro that contained the next line#define.Test-LookupNow it seems that the "-" does not work. Only

Re: [Axapta-Knowledge-Village] AOS on SQL server Cluster problem ????

2005-03-07 Thread Varden Morris
ve any problem ( network ..etc ) , the cluster will automatically move the SQL server to  the second database server ( of course we should assign that second database into cluster administration ).   - Original Message - From: Varden Morris To: Axapta-Knowledge-Village@yahoogroups.com

Re: [Axapta-Knowledge-Village] how to minimize blocking on axapta ?

2005-03-07 Thread Varden Morris
iguration. for memory , we already enabled AWE memory . thx sas       - Original Message - From: Varden Morris To: Axapta-Knowledge-Village@yahoogroups.com Sent: Saturday, March 05, 2005 1:24 AM Subject: Re: [Axapta-Knowledge-Village] how to minimize blocking on axapta ? Hi Sas   The

Re: [Axapta-Knowledge-Village] Needed to find out which Class

2005-03-04 Thread Varden Morris
Hi Padmaja   You are very close there. The classes are PurchFormLetter_PackingSlip and PurchFormLetter_Invoice. There inherit the PurchFormLetter class. The reports are PurchInvoice and PurchPackingSlip.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingsto

Re: [Axapta-Knowledge-Village] how to minimize blocking on axapta ?

2005-03-04 Thread Varden Morris
uspect it's bacuse our coding . my experience tuning hardware , OS and  SQL server only give 10% improvement, table indexing also improve the performance . and now we are investigating our coding. thx sas    - Original Message ----- From: Varden Morris To: Axapta-Knowledge-Village@yahoogroup

Re: [Axapta-Knowledge-Village] AOS on SQL server Cluster problem ????

2005-03-04 Thread Varden Morris
Hi Sas   Could you please explain what you mean by "move from DB server1 into db Server 2."   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2226Fax:  (876) - 923 - 5372 C

RE: [Axapta-Knowledge-Village] how to minimize blocking on axapta ?

2005-03-03 Thread Varden Morris
not needed.. Would you agree?   Rocco From: Varden Morris [mailto:[EMAIL PROTECTED] Sent: Wednesday, 2 March 2005 7:59 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] how to minimize blocking on axapta ? The two main things I know can affect blocking are hardwa

Re: [Axapta-Knowledge-Village] Persisting the result of a job execution

2005-03-02 Thread Varden Morris
Why is it that you must use a job?Giray Simsek <[EMAIL PROTECTED]> wrote: Varden,Thank you for your suggestion. However, I have to usea job so I can't use your solution.Giray.--- Varden Morris <[EMAIL PROTECTED]> wrote:> Giray>  > Create a class with a static method

Re: [Axapta-Knowledge-Village] Persisting the result of a job execution

2005-03-02 Thread Varden Morris
sName", "MethodName", Parameter1)   The parameter is optional and you can have up to six of them. You will have to use a parameter list for more.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2

Re: [Axapta-Knowledge-Village] how to minimize blocking on axapta ?

2005-03-02 Thread Varden Morris
help to you.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2226Fax:  (876) - 923 - 5372 Cell:  (876) - 3833566Email:   [EMAIL PROTECTED]     [EMAIL PROTECTED]SAS <[EMAIL PROTECTED]> w

Re: [Axapta-Knowledge-Village] Storage dimension

2005-03-02 Thread Varden Morris
I think you have to purchase additional ones from your VAR.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2226Fax:  (876) - 923 - 5372 Cell:  (876) - 3833566Email:   [EMAIL PROTE

RE: [Axapta-Knowledge-Village] Edit problem on form

2005-02-23 Thread Varden Morris
Sorry. Here is the attachment.     Ashi Singh <[EMAIL PROTECTED]> wrote: A lot of thanks for showing a interest in my problem what i thought is a better idea is to just send you all the xpo's which are there in my project.   Again thanks a lot i am working on whatever links that you have pr

Re: RE : [Axapta-Knowledge-Village] Temporary table

2005-02-21 Thread Varden Morris
You are most welcome.Steeve Gilbert <[EMAIL PROTECTED]> wrote: Thank Varden for the answer.   Ashi,  what seems to be the problem here?  It is working has expected.  I've tried that :   static void Job1(Args _args){     TmpSum tmpSum, p1, p2;       ;     tmpSum.Key = "1";     tmpSum.insert

Re: [Axapta-Knowledge-Village] Temporary table

2005-02-18 Thread Varden Morris
Hi   After populating tmpSum you do the following:   p1.setTmpData(tmpSum); p2.setTmpData(tmpSum); That should do he trick. Varden Steeve Gilbert <[EMAIL PROTECTED]> wrote: (See job below)   I though I would see in the infolog "1,2,3,1,2,3" but that is not he case, I see "1,2,3".  It seems

Re: [Axapta-Knowledge-Village]

2005-02-11 Thread Varden Morris
Projinvoicetable.InvoiceAccount == custtable.AccountNum;   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2226Fax:  (876) - 923 - 5372 Cell:  (876) - 3833566Email:   [EMAIL PROTECTED]     [E

Re: [Axapta-Knowledge-Village] Re: Subquery

2005-01-29 Thread Varden Morris
Hi Anton   If you did not use my previous example you may use this:       select * from CustTable where CustTable.createddate ==     (select maxof(createddate) from Custtable).createddate;Varden Morris <[EMAIL PROTECTED]> wrote: Hi Anton,   The way you may get around this prob

Re: [Axapta-Knowledge-Village] AOS Install Help..

2005-01-27 Thread Varden Morris
.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2226Fax:  (876) - 923 - 5372 Cell:  (876) - 3833566Email:   [EMAIL PROTECTED]     [EMAIL PROTECTED]   tj_jayson <[EMAIL PROTECTED]>

Re: [Axapta-Knowledge-Village] Com Connector

2005-01-25 Thread Varden Morris
Hi Rocco,   As far as I know you will have to register both of them on separate computers if you want to use both at the same time. Only one COM connector can be registered and use on a compter at a time.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingsto

Re: [Axapta-Knowledge-Village] Re: Subquery

2005-01-25 Thread Varden Morris
from custTable where LTRIM(Accountnum) = '%1' AND " + "Name like '%a%'", "11");SQLcustTrans = sqlStmt.executeQuery(sqlSTR); while (SQLcustTrans.next()){    print SQLcustTrans.getString(1);    pause;} Varden Morris   J. Wray & Nephew Ltd. - Grou

Re: RE : [Axapta-Knowledge-Village] Does anybody know how I can prevent a form from closing but should minimize

2005-01-21 Thread Varden Morris
I think this way is a smart way of doing it. In order for it to work you will have to override the canClose method instead of the close method. As steeve said, you only need the code for SC_MINIMIZE. Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jam

Re: [Axapta-Knowledge-Village] Axapta Object Servers

2005-01-19 Thread Varden Morris
Hi Morris,   The first thing I would do is check the application log in event viewer for the error. Based on that we will have a better idea of how to help you.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 -

Re: [Axapta-Knowledge-Village] Invoice Posting

2005-01-18 Thread Varden Morris
This is possible using the Axapta Business Connector. You can use VBA in excel to upload the data via the Business Connector. When you use the Business Connector all the business logics in Axapta are available for posting and validation.   Varden Morris   J. Wray & Nephew Ltd. - Group

Re: Re[2]: [Axapta-Knowledge-Village] Refresh Form from Table

2005-01-17 Thread Varden Morris
You are most welcome.kam tt <[EMAIL PROTECTED]> wrote: Thank you Varden and Max,"_ds" is cool. You guys certainly make my day.Regards,kamtt--- Varden Morris <[EMAIL PROTECTED]>wrote:> It is normal for users to see what was in the table> before they open a form. Th

Re: [Axapta-Knowledge-Village] how to determine the best location of validate method?

2005-01-17 Thread Varden Morris
in the form. This makes a control the third and I think the last best place to write code.   It is best practice to place no code if possible on a form. This makes the form simple and easy to maintain and reduces the cost of upgrades.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spa

Re: Re[2]: [Axapta-Knowledge-Village] Refresh Form from Table

2005-01-13 Thread Varden Morris
It is normal for users to see what was in the table before they open a form. The reread and refresh on the datasource allows users to see new updates/inserts.Max Belugin <[EMAIL PROTECTED]> wrote: Hello Varden Morris,÷åòâåðã, 13 ÿíâàðÿ 2005 ã., you wrote:VM> After you have done an

Re: [Axapta-Knowledge-Village] Refresh Form from Table

2005-01-13 Thread Varden Morris
Hi Kamtt   After you have done an update to PurchTable execute the following code:   PurchTable _ds.reread();PurchTable _ds.refresh(); Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2400, 2412Fax: 

Re: [Axapta-Knowledge-Village] VAR/USR Layer changes and data

2005-01-10 Thread Varden Morris
doinf this.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2400, 2412Fax:  (876) - 923 - 5372 Cell:  (876) - 3833566Email:   [EMAIL PROTECTED]     [EMAIL PROTECTED]    D

Re: [Axapta-Knowledge-Village] printing invoice or picking list

2005-01-10 Thread Varden Morris
Hi Jesmond   The class name is SalesFormLetter.Jesmond Giordimaina <[EMAIL PROTECTED]> wrote: Hi, can anyone highlight which class shall I use for printing an invoice or picking list? reg Jesmond Do you Yahoo!?The all-new My Yahoo! – Get yours free! Sharing the knowledge on Axapta. Do you

Re: [Axapta-Knowledge-Village] SQL database error -> equal to-operation

2005-01-10 Thread Varden Morris
Try synchronizing the inventTable.Stefan Heidkamp <[EMAIL PROTECTED]> wrote: Hi all,when we want to open the form InventTable or the menu item InventTable (under display) we get the following error:Cannot select a record in table Item table (InventTable).The SQL database has issued an error.SQ

Re: [Axapta-Knowledge-Village] Group by in X++ ??

2005-01-08 Thread Varden Morris
Hi Anton,   I tried this in a job andI didn't get any error:       Query q = new Query();    QueryBuildDataSource dsSalesTable;    QueryBuildDataSource dsSalesLine;    QueryRun qr;    SalesTable   SalesTable;     dsSalesTable = q.addDataSource(tablenum(SalesTable));    dsSal

Re: [Axapta-Knowledge-Village] Layer Question

2005-01-04 Thread Varden Morris
seeif the modified tables (new fields added) have thedata , If you do have the data then you need to exportthese data and then when importing this data you needto select  to update the existing data.good luck.--- Varden Morris <[EMAIL PROTECTED]> wrote: > Login to the CUS layer  and expo

Re: [Axapta-Knowledge-Village] Axapta on windows cluster

2005-01-04 Thread Varden Morris
.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2400, 2412Fax:  (876) - 923 - 5372 Cell:  (876) - 3833566Email:   [EMAIL PROTECTED]     [EMAIL PROTECTED]   Alessandro Ghidini <[EMAIL PROTECTED]

Re: [Axapta-Knowledge-Village] Layer Question

2005-01-04 Thread Varden Morris
Login to the CUS layer  and export the required objects from  this layer. Best to do this in a project. After doing this you then delete the objects from the CUS layer. Logout of Axapta and login to the VAR layer. Import the project you have exported from the CUS layer.   Varden Morris   J

Re: [Axapta-Knowledge-Village] Inventory Closing Whitepaper

2004-12-30 Thread Varden Morris
Hi Jason,     Could you please fwd that file to me. I dont have access to partner source :( .   Thanks and Regards   Varden Morris jasondinham <[EMAIL PROTECTED]> wrote: Everyone who uses inventory in Axapta should review the Inventory Closing Whitepaper posted on Partner Source.  Let m

Re: [Axapta-Knowledge-Village] EDT -> Dimensions

2004-12-20 Thread Varden Morris
You can try this:   range1 = dsInventTable.addRange(fieldid2ext(fieldnum(InventTable,Dimension),1)) OR range2 = dsInventTable.addRange(fieldid2ext(fieldnum(InventTable,Dimension),2)) OR range3 = dsInventTable.addRange(fieldid2ext(fieldnum(InventTable,Dimension),3)) Varden Morris   J. Wray

Re: [Axapta-Knowledge-Village] How to read temporary table

2004-12-20 Thread Varden Morris
I think you need to do something like this:   tmpTab = this.Process_InventSum(BranchId,ItemGroup); You are just calling the method (this.Process_InventSum(BranchId,ItemGroup) but you are not capturing the return value. Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town

Re: [Axapta-Knowledge-Village] Problem to select purchase order lines by packing slip number on invoice

2004-12-11 Thread Varden Morris
Hi Arijit   If you have two AOS (say AOS1 and AOS2) running in a cluster and you logon to Axapta and hit AOS1 all the users who are on AOS1 will show up as "Thin Client" while all the users on AOS2 will show up as "Not AOS". The converse it also true.Arijit Basu <[EMAIL PROTECTED]> wrote: Dear

Re: [Axapta-Knowledge-Village] Axapta 3.0 Macro Questions

2004-12-10 Thread Varden Morris
Most of the following information is from the Developer’s Guide. A macro is a code or text substitution that cannot run independently, but can be used anywhere you can write code in the system, for example in jobs, classes and forms.   MorphX has a built-in macro-preprocessor. The purpose of m

Re: [Axapta-Knowledge-Village] Sample code for IAxaptaBufferData

2004-12-08 Thread Varden Morris
x27;t need to create this file before.'Check the content of this file after code executionBuffer.WriteFile "C:\MyWriteFile2.Txt" Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2400, 2412Fax:  (

RE: [Axapta-Knowledge-Village] Executing Report from a self made form

2004-12-07 Thread Varden Morris
In the Microsoft Axapta Developer's Guide from the help menu do a search for Axapta Business Connector. After you read the first four pages there are several VB 6.0 examples that follow.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jam

Re: [Axapta-Knowledge-Village] Executing Report from a self made form

2004-12-07 Thread Varden Morris
Sorry.   A correction is needed for the third sentence below. It should say "Set the class property to class and the object property to the name of the class."Varden Morris <[EMAIL PROTECTED]> wrote: It is Axapta’s standard/best practice to create a class to load your report.

Re: [Axapta-Knowledge-Village] Executing Report from a self made form

2004-12-07 Thread Varden Morris
MenuItemType to output and the MenuItemName to the name of the MenuItem created. Set any other required properties of the MenuItemButton. Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2400, 2412Fax:  (876) -

RE: [Axapta-Knowledge-Village] constructor problem or ..

2004-12-06 Thread Varden Morris
7;, 'Text2');   or   MyObject myObject = new MyObject('Text1', 'Text2', 'Text3');   and so on.   Or you could declare the first parameter or first few parameters without initial values and the others with initial values. This means that you have to pass values f

RE: [Axapta-Knowledge-Village] Section Printing in Report.

2004-12-06 Thread Varden Morris
;t print it. The curly brackets are not necessary in the case since only one statement follows but I use it for illustration.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone: (876) - 923 - 6141 Ext. 2400, 2412Fax: (876) -

RE: [Axapta-Knowledge-Village] Section Printing in Report.

2004-12-06 Thread Varden Morris
(); }   This means that if whatever function value you are checking for is not equal to zero print the section otherwise don't print it. The curly brackets are not necessary in the case since only one statement follows but I use it for illustration.   Varden Morris   J. Wray & Nephew Ltd. - Group

RE: [Axapta-Knowledge-Village] AOS required for Enterprise Portal?

2004-12-03 Thread Varden Morris
firewall it is open to the world. But the more tiers you add to your configuration the more performance will degrade as a result of the network hops. You could optimize the links between the firewalls and the web sever by using high speed network card/connections. Varden Morris   J. Wray & Ne

RE: [Axapta-Knowledge-Village] AOS required for Enterprise Portal?

2004-12-03 Thread Varden Morris
You are most welcome.James Flavell <[EMAIL PROTECTED]> wrote: Thank you very much Varden -Original Message-From: Varden Morris [mailto:[EMAIL PROTECTED]Sent: 03 December 2004 20:37To: [EMAIL PROTECTED]Subject: Re: [Axapta-Knowledge-Village] AOS required for Enterprise Portal?

Re: [Axapta-Knowledge-Village] AOS required for Enterprise Portal?

2004-12-03 Thread Varden Morris
additional users as the number of users grow but with 2-Tier the performance will fall drastically when the number of users exceed a certain limit which depends on things like sever specs and type of communication links.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town

Re: [Axapta-Knowledge-Village] add field to table

2004-12-03 Thread Varden Morris
added to the table to this node and save the table. Go back to the inventTable form and look at the fields listed under the identification group and you will see you new field added automatically.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica,

Re: [Axapta-Knowledge-Village] Re: Select Distinct

2004-12-03 Thread Varden Morris
You are most welcome.axaptagrp <[EMAIL PROTECTED]> wrote: thanks Vardenthats exactly what I had to do!Best Regards,John Chircop.--- In [EMAIL PROTECTED], Varden Morris <[EMAIL PROTECTED]> wrote:> You can use Microsoft SQL statements directly in X++. Insert the following code in

Re: [Axapta-Knowledge-Village] Axapta business logic from other applications

2004-12-01 Thread Varden Morris
tor in the Microsoft Axapta Developer's Guide for details.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2400, 2412Fax:  (876) - 923 - 5372 Cell:  (876) - 3833566Email:   [EMAIL PROTECTED]  

Re: [Axapta-Knowledge-Village] Select Distinct

2004-11-29 Thread Varden Morris
You can use Microsoft SQL statements directly in X++. Insert the following code in a job and test it:       Connection  con = new Connection();    Statement   sqlStmt = Con.createStatement();    ResultSet   SQLcustTrans;    Notes sqlStr    ;     sqlStr =strFmt("select * from custTable wh

Re: [Axapta-Knowledge-Village] Load form from object / class

2004-11-25 Thread Varden Morris
If the form 'KompForm' exists in the AOT do the following:       FormRun Komp;     Komp= new FormRun(new args('KompForm'));     Komp.init();    Komp.run();    Komp.wait();affekatz <[EMAIL PROTECTED]> wrote: Can any one tell me how to load a form from a object this dosn't seem to work:   

Re: [Axapta-Knowledge-Village] StingEdit in Form

2004-11-25 Thread Varden Morris
as follows: My_komp1.text('It works'); Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2400, 2412Fax:  (876) - 923 - 5372 Cell:  (876) - 3833566Email:   [EMAIL PROTECTED]     [EMAIL PROTEC

Re: [Axapta-Knowledge-Village] Purchase Forecast Import

2004-11-25 Thread Varden Morris
the fileds in there correct positions. From there you may use Axapta to import the data from the template sheet. Hope that will help. Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2400, 2412Fax:  (876) -

RE: [Axapta-Knowledge-Village] SQL License

2004-11-19 Thread Varden Morris
by using 3-tier it may still work out cheaper to go with the processor license.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2400, 2412Fax:  (876) - 923 - 5372 Cell:  (876) - 3833566Email:   [E

RE: [Axapta-Knowledge-Village] SQL License

2004-11-17 Thread Varden Morris
sure about the number SQL uses in the pooling but I did a rough check and found 61 connections to SQL when 81 users login to Axapta. This means a 25% reduction in the number of required connections.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica,

Re: [Axapta-Knowledge-Village] A field in the first page of a report

2004-11-11 Thread Varden Morris
you would executed the programmableSection outside the loop where you send the detail lines to the report.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2400, 2412Fax:  (876) - 923 - 5372 Cell: 

Re: [Axapta-Knowledge-Village] Re: initialize

2004-11-11 Thread Varden Morris
roduct configurator that's included in Axapta Varden Morris <[EMAIL PROTECTED]> wrote: I do not know exactly what is product builder. Is it a third party software? if you do the following:   [class]public class AB{int x;int y;}[New]void new(int c = 0, int d = 0){x = c;y = d;} The above is

Re: [Axapta-Knowledge-Village] Re: initialize

2004-11-11 Thread Varden Morris
ct builder. I notice that your call from product builder does not hold a handle to the object for future use if you intend to return value(s) from the object with an accessor method. Provided that you get this to work I will help you with the rest. Varden Morris   J. Wray & Nephew Ltd. -

Re: [Axapta-Knowledge-Village] initialize

2004-11-10 Thread Varden Morris
to an instance of the object as follows:   A = new xx();     Or you could have done it all in one statement as follows:   xx A = new xx();   You may now use the handle to access the object by calling the object's methods.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish

Re: [Axapta-Knowledge-Village] How omit Printing fields that contain blanks in PurchInvoice report?

2004-11-09 Thread Varden Morris
Hi Bob   You can do this by overriding the executeSection method of the report section that prints the lines on the report. Enclose the super() call in an if statement that will not allow it to be executed when the required conditions are not met.  Varden Morris   J. Wray & Nephew Ltd. - G

RE: [Axapta-Knowledge-Village] Re: Table that store user and password

2004-11-09 Thread Varden Morris
the System Documenation node of the AOT then tables. The system tables are listed under this node and you will find the UserInfo table there.   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2400, 241

<    1   2   3   4   >