RE: [Axapta-Knowledge-Village] Error Msg

2007-11-29 Thread Bayliss, Barry
Ricardo, What version of Axapta are you using as I have successfully overloaded the insert and update statements on a number of tables. For example, on the EmplTable void insert ( boolean Force = false, boolean

[Axapta-Knowledge-Village] RE: [development-axapta] Merging Axapta databases (recovery of lost data)

2007-03-25 Thread Bayliss, Barry
. -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Bayliss, Barry Sent: Monday, 19 March 2007 4:59 PM To: development-axapta@yahoogroups.com Cc: Axapta-Knowledge-Village@yahoogroups.com Subject: [development-axapta] Merging Axapta databases

[Axapta-Knowledge-Village] Merging Axapta databases (recovery of lost data)

2007-03-18 Thread Bayliss, Barry
Hello, I was wondering if anyone has any information to help resolve this issue. Recently we had a database crash due to corruption. We found out that the database backups had also been corrupted for the previous several days, as a result we restored a database that was

[Axapta-Knowledge-Village] Kernel rollup problem

2006-05-30 Thread Bayliss, Barry
Hello, We are experiencing an unusual problem in relation to the kernel rollup. What we have noticed is that the kernel rollup appears to have modified several extended data types; by deleting the layer modifications we have made (CUS and USR layer). The main EDTs which we have noticed

RE: [Axapta-Knowledge-Village] Re: [development-axapta] editing class method without opening the class

2006-05-16 Thread Bayliss, Barry
Hema, To find the line: You can divide a string by using Container = Str2con(text1, separator); From the information given by Max, use the separator as \n. Thus the line you are after can be retrieved by Line string = ConPeek(container, line

RE: SV: SV: [Axapta-Knowledge-Village] how do i get the database server names, database names

2006-05-14 Thread Bayliss, Barry
('Valid connection'); } } } } } catch (Exception::Error) { error(Please check the data entered. Connection could not be established based on the values provided); } regs, Hema. S Bayliss, Barry [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent by: cc

RE: [Axapta-Knowledge-Village] editing class method without opening the class

2006-05-14 Thread Bayliss, Barry
Hema, Is there a reason why what to add a line to a class without opening it? Barry. -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, 12 May 2006 6:31 PM To:

RE: SV: SV: [Axapta-Knowledge-Village] how do i get the database server names, database names

2006-05-10 Thread Bayliss, Barry
Hema, There is a simpler way to do this, and it can be done using X++. Here is an extract of code I use ODBCConnection FormConnection ( ) { #PCDMacro LoginProperty loginDetails = new LoginProperty(); ODBCConnection currentconnection; str Database, CurrentServer,

RE: SV: [Axapta-Knowledge-Village] how do i get the database server names, database names

2006-05-09 Thread Bayliss, Barry
Hema, Is there are reason why you need to do this by code? Why not: 1. Use enterprise manager, add the database server and examine the databases that way. 2. Ask the system administrator. Barry. -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL

RE: RE : [Axapta-Knowledge-Village] How to find the data type of the field

2006-04-25 Thread Bayliss, Barry
Hi VG, If I understand you correctly, the function you are after is TypeOf(). Here is a quick example. static void Job280(Args _args) { CustTable CustTable; ; info(strfmt(%1,typeOf(CustTable.AccountNum))); } -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com

RE: [Axapta-Knowledge-Village] Re: Urgent Axapta Security Issue

2006-04-05 Thread Bayliss, Barry
jimbow3012, We recently had a problem with a form showing controls incorrectly for a user. Found that rebuilding the index corrected the issue. Barry. -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hardi Sent: Wednesday, 5

RE: [Axapta-Knowledge-Village] Tables related to Item

2006-03-13 Thread Bayliss, Barry
Use the cross-reference information. It is possible to do. Barry. -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of V G Sent: Tuesday, 14 March 2006 6:28 AM To: development-axapta@yahoogroups.com;

RE: [Axapta-Knowledge-Village] ZipCodeLookup

2006-02-28 Thread Bayliss, Barry
Brandon, Which service pack are you running on? Have you made any modifications? We use sp2 and the ZipCode lookup runs as I would expect. Australia has multiple cities per postcode (zipcode). Basically we select the zipcode (postcode), and then have to select the appropriate city if there

RE: [Axapta-Knowledge-Village] Axapta Error

2006-02-27 Thread Bayliss, Barry
Why it is happening on the sysLastValue, not sure. For the other tables I once had a similar problem. Was the result of setting the saveDataPerCompany option to No (there was data already in the table for various companies). Forgot how I deleted the duplicate record, was either enterprise

RE: (BUG}[Axapta-Knowledge-Village] Limit on attaching POs to a blanket Order

2006-01-23 Thread Bayliss, Barry
Subbu, I would be interested in the support email, as the situation I reported does not relate to the number of nested loops, but to the resulting string length of the query definition. Barry. -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED]

RE: [Axapta-Knowledge-Village] Axapta programming version control

2006-01-05 Thread Bayliss, Barry
. By environment I mean same code base or folder. Andrew -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Bayliss, Barry Sent: Wednesday, January 04, 2006 2:34 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE

RE: [Axapta-Knowledge-Village] Axapta programming version control

2006-01-04 Thread Bayliss, Barry
@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Bayliss, Barry Sent: Monday, January 02, 2006 3:04 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Axapta programming version control Hello Andrew, We successfully integrated visual source safe

RE: [Axapta-Knowledge-Village] Axapta programming version control

2006-01-04 Thread Bayliss, Barry
: Hi, I'm also interested in such a solution, for no more than 2 developers and working on the same layer/application. How is the Visual Source Safe integration with Axapta acomplished? Bayliss, Barry wrote: Hello Andrew, We successfully integrated visual source safe with Axapta

RE: [Axapta-Knowledge-Village] Axapta programming version control

2006-01-02 Thread Bayliss, Barry
Hello Andrew, We successfully integrated visual source safe with Axapta, which allows us to keep a history of the objects. If you have multiple developers working on Axapta modifications, both internal and external, you are likely to run into other problems. Are all the developers working in

RE: [Axapta-Knowledge-Village] Re: Performance

2006-01-02 Thread Bayliss, Barry
RAID 5 for write intensive operations). This procedure will enahace performance. Bayliss, Barry [EMAIL PROTECTED] wrote: Yes, was referring to the sql transaction log. Can you post your code? Barry. -Original Message- From: Axapta[EMAIL PROTECTED] [mailto:Axapta[EMAIL PROTECTED

RE: [Axapta-Knowledge-Village] Re: Performance

2005-12-20 Thread Bayliss, Barry
Hello Stefan, I have previously come across a problem with a piece of code running slower like this. Turns out the problem was related to the size of the transaction log generated by the process being run. Have you placed the transaction log around the entire batch, or each block of the

RE: [Axapta-Knowledge-Village] Performance Issue

2005-12-20 Thread Bayliss, Barry
Hello, I found the following: 1. Using the TextBuffer method 0.14 seconds. 2. Using r = r + a 72.14 seconds 3. Using r += a 0.06 seconds So you may want to use either the textBuffer method, or the += operator. Barry. From: Axapta[EMAIL PROTECTED]

RE: [Axapta-Knowledge-Village] Adding Combo Box on CustTable Form

2005-12-18 Thread Bayliss, Barry
Kevin, At the time you added the combo box to the form, did you modify / add any new code either to the CustTable table or CustTable form? Barry. -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of kevstar25 Sent: Saturday, 17

RE: [Axapta-Knowledge-Village] problem in Exporting and Importing Excel Worksheets

2005-12-08 Thread Bayliss, Barry
Hello Mukesh, The InventSum table CAN be exported using the template wizard. To do this: 1. Open the AOT 2. Examine the properties of the table InventSum, mainly looking for the Label of the table. Subbu, if you see the inventSum table after the inventSize table using the

RE: [Axapta-Knowledge-Village] Best Practice error (Wrong security key. Security key must match position in main menu)

2005-12-05 Thread Bayliss, Barry
Vikas Garg (Technical Consultant) EuroInfo Systems Pvt. Ltd. Sector 2, Noida. Direct No - +91-9911213322 Office No - +91-120-2520414 ext. 213 From: Axapta[EMAIL PROTECTED] [mailto:Axapta[EMAIL PROTECTED]] On Behalf Of Bayliss, Barry Sent: Monday, December 05, 2005 4:06 AM To: Axapta

RE: [Axapta-Knowledge-Village] Best Practice error (Wrong security key. Security key must match position in main menu)

2005-12-04 Thread Bayliss, Barry
Hello Vikas and Varden, As a quick test I added to a menu item (display) a security key that did not have a parent set. When I compiled the project, I did not receive the best practices error discussed. NOTE: 1. Tried the menu item with and without a configuration key. 2. We

RE: [Axapta-Knowledge-Village] Audit trail for COA

2005-12-04 Thread Bayliss, Barry
Sherin, Have you considered changing the table's properties to track the items you listed? Barry. -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of sherin_gf Sent: Sunday, 4 December 2005 5:43 PM To:

RE: RE : [Axapta-Knowledge-Village] Grid, HighlightActive

2005-11-17 Thread Bayliss, Barry
I grid concerned was called Grid, and the autodeclare property was set to Yes. I mean after the super() call. The code I used was public int active() { int ret; ret = super(); grid.update(); return ret; } Hope this clears up the issue. Barry. -Original Message-

RE: [Axapta-Knowledge-Village] COM+ Test error

2005-11-17 Thread Bayliss, Barry
Alejandro, Has this issue been solved? What was the problem? Barry. -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Alejandro Ibarra Sent: Wednesday, 9 November 2005 4:43 AM To: Axapta-Knowledge-Village@yahoogroups.com

RE: [Axapta-Knowledge-Village] COM+ Test error

2005-11-17 Thread Bayliss, Barry
to use the interactive user option. 7.- The user that i use to register Axapta Business Connector is an Axapta valid user, and the password, it also have the configuration keys to manage the business connector. Bayliss, Barry [EMAIL PROTECTED] escribió: Alejandro, Has this issue been solved

RE: RE : [Axapta-Knowledge-Village] Grid, HighlightActive

2005-11-16 Thread Bayliss, Barry
On the Active method of the data source for the grid, add the line Grid.update(); In my test form, I placed the above line after the super call. Barry. -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steeve Gilbert Sent:

RE: [Axapta-Knowledge-Village] COM+ Test error

2005-11-09 Thread Bayliss, Barry
You use have a licence code to use COM clients? If so, how many? Are any other COM connections currently in use? Barry. -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Alejandro Ibarra Sent: Wednesday, 9 November 2005

RE: RE : [Axapta-Knowledge-Village] Performance analysis

2005-10-20 Thread Bayliss, Barry
Steeve, There are several tools which I regularly use to speed up performance without upgrading hardware: Tools option SQL Select the SQL trace option. Enter in the threshold value for your query Select the appropriate options Tools option

RE: [Axapta-Knowledge-Village] To add or not to add an index?

2005-09-28 Thread Bayliss, Barry
James, One possible way to determine the best solution is to run a test script and time the process. You might try the combinations 1. Temporary table with unique index 2. Permanent table with unique index 3. Temporary table with an index and in code check for

[Axapta-Knowledge-Village] Forms

2005-09-22 Thread Bayliss, Barry
Hello, I have a couple of quick questions. Is it possible to determine the forms a user has open from within their session, without storing information about the form as it is opened in a table? When control is transferred between forms, i.e. the user selects

RE: [Axapta-Knowledge-Village] Re: Need help in Axapta X++ code

2005-09-13 Thread Bayliss, Barry
Mollar, Running a generic piece of code on the opening of each form is start forward. Please let me know if this is still an issue. Barry. -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of eng_mollar Sent: Monday, 5

RE: [Axapta-Knowledge-Village] Re: Technical questions help needed

2005-09-05 Thread Bayliss, Barry
The answer for item#16 is letter c. Thanks, patrick --- In Axapta-Knowledge-Village@yahoogroups.com, Bayliss, Barry [EMAIL PROTECTED] wrote: Hello, While I do not have the answers for your technical questions, I am interested in the answer to this question. We have had different

RE: [Axapta-Knowledge-Village] Adding a new inventory dimension to Axapta

2005-08-04 Thread Bayliss, Barry
Title: Message James, Are you trying to: 1. Add a new dimensional field 2. Add a new dimensional value to an existing dimensional field? Barry. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of James Flavell Sent: Thursday,

RE: [Axapta-Knowledge-Village] Adding a new inventory dimension to Axapta

2005-08-04 Thread Bayliss, Barry
field Thanks James -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Bayliss, Barry Sent: 05 August 2005 07:22 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Adding a new inventory

[Axapta-Knowledge-Village] Views in Axapta 3.0

2005-08-04 Thread Bayliss, Barry
Title: Message Hello, Does anyone have any information on how to use views (in the AOT) in Axapta 3.0? I have examined my copy of the X++ Advanced notes and there is no information in it on them. Thanks in advance. Barry. Sharing the knowledge on Axapta.

FW: [Axapta-Knowledge-Village] Simple Question :-) : what is the array lenght?

2005-06-01 Thread Bayliss, Barry
Hello Subbu, Here is an example showing how to get the array size array i; ; i = new array(types::Integer); i.value(1,3); i.value(2,7); i.value(3,5); i.value(4,9); print i.lastIndex(); pause; A good place to find information like this is in the help

RE: RE : [Axapta-Knowledge-Village] SP4

2005-05-24 Thread Bayliss, Barry
Id be interested in the information as well. Barry. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Jesper Kehlet Sent: Wednesday, 25 May 2005 5:39 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: RE :

RE: [Axapta-Knowledge-Village] Modify the Class property

2005-05-12 Thread Bayliss, Barry
hi Akash, Just a couple of quick questions: 1. If you modify the code of a function in the class, does this coding change get imported into the customer application? 2. Are the functions you are trying to call in the class static? 3. Can you send to the list the class declaration of the

[Axapta-Knowledge-Village] Crash logs

2005-05-11 Thread Bayliss, Barry
Hello, Does anyone have any references / information on how to use the information contained in the crash log to determine if (and what) coding modifications may be at fault? An example of a recent crash log has been attached at the end of this message. Note, we have not yet found a way to

RE: [Axapta-Knowledge-Village] Re: X++ Projects

2005-05-05 Thread Bayliss, Barry
; } --- In Axapta-Knowledge-Village@yahoogroups.com, Bayliss, Barry [EMAIL PROTECTED] wrote: Hello, Does anyone know: 1. If it is possible to add objects to a project programmatically? If so, how? 2. How to create a project programmatically? 3. If it is possible to add a new project

[Axapta-Knowledge-Village] X++ Projects

2005-04-26 Thread Bayliss, Barry
Hello, Does anyone know: 1. If it is possible to add objects to a project programmatically? If so, how? 2. How to create a project programmatically? 3. If it is possible to add a new project grouping? Barry. Yahoo! Groups Sponsor ~-- In

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

2005-04-19 Thread Bayliss, Barry
If you're looking for the label in code, you could (as an alternative) 1. Open the AOT 2. Right mouse click on the top level 3. Select the FIND option 4. Enter the label identifier in the CONTAINING TEXT, eg SYS1011 Note: 1. This method of finding the label use can take some time. 2. Might be

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

2005-04-14 Thread Bayliss, Barry
Try using Throw exception::error instead of throw error(). From: Raul Llorente Peña/OPENSOLUTIONS [mailto:[EMAIL PROTECTED] Sent: Thursday, 14 April 2005 8:25 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Why sentence try/catch

RE: RE: RE: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?

2005-03-09 Thread Bayliss, Barry
Raul, Are you able to post the code that generates the error? Barry. From: Raul Llorente Peña/OPENSOLUTIONS [mailto:[EMAIL PROTECTED] Sent: Sunday, 6 March 2005 6:54 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: RE: RE: RE:

RE: Re: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?

2005-03-03 Thread Bayliss, Barry
Raul, Are you able to post the code you use to call the COM object, as well as the code behind the object being called. Barry. From: Raul Llorente Peña/OPENSOLUTIONS [mailto:[EMAIL PROTECTED] Sent: Thursday, 3 March 2005 11:07 PM To:

RE: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?

2005-03-02 Thread Bayliss, Barry
. The record already exists). X may be an apparently alleatory table. And I need to track so. Tool of log of database doesn't fit this... Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS -Bayliss, Barry [EMAIL

RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?

2005-02-24 Thread Bayliss, Barry
Hello Raul, Why is it that you need to find the recID for before the insertion? Barry. From: Raul Llorente Peña/OPENSOLUTIONS [mailto:[EMAIL PROTECTED] Sent: Thursday, 24 February 2005 3:08 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject:

RE: [Axapta-Knowledge-Village] Return Array of Class

2005-02-21 Thread Bayliss, Barry
Krish, Another way would be to use containers. Your code would be something like Container Initialise ( ) { Container Results; class1 class1; ; while select table1 where

[Axapta-Knowledge-Village] Programmatically removing controls from a form

2004-10-28 Thread Bayliss, Barry
Title: Programmatically removing controls from a form Hello, As it is possible to programmatically add controls to a form at runtime, is it also possible to remove controls, instead of making them invisible? I am using Axapta 3.0 sp2. I have tried using the following code, with no

[Axapta-Knowledge-Village] Colour within a tree controller

2004-08-31 Thread Bayliss, Barry
Title: Colour within a tree controller Hello, Is it possible to have multiple items within a tree contorller with each with a different text colour? If so, how? Thanks. Barry. This email contains information from GS Engineering Services Pty Ltd, GS Services Electrical Pty Ltd