RE: [development-axapta] Re: Stranger problem with Query

2007-11-29 Thread Bayliss, Barry
Jorge, Can you post 1. The complete code in the method (not just a snipet) 2. When you debug the code, the value of the qbds variable. 3. If there are any errors when you do a table synchronisation 4. Any errors in the method when you compile the entire Axapta application

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

2007-03-26 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

[development-axapta] Merging Axapta databases (recovery of lost data)

2007-03-19 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

[development-axapta] 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: [development-axapta] Could not continue scan with NOLOCK due to data movement.

2006-05-24 Thread Bayliss, Barry
Ieva, It is my understanding that the data in the table you were examining has changed. The process you use to examine the data has not placed a lock on the table. In this case you are examining a transactions table, and data has either been modified, inserted or deleted. Barry.

RE: Re[2]: [development-axapta] editing class method without opening the class

2006-05-24 Thread Bayliss, Barry
As a rule, each line in code should start with a character, so this should not be an issue. Just in case, you can modify the str2Con method to not convert the data. We have done this as it works (remember to make the added parameter optional). -Original Message- From:

RE: [development-axapta] View doesn't use indexes

2006-04-04 Thread Bayliss, Barry
Steeve, I have recently started using views to improve performance, and have not noticed the issue you are raising. Given that BOAOrderToProduce and BOAOrderToProduceGrouped are not defined on our system, it is possible for you to send me a copy of the xpo? Barry. -Original

RE: [development-axapta] where DLL files exist

2006-04-03 Thread Bayliss, Barry
Trupti, I am curious why placing the DLL function on the server will cause registration and security problems. While I work on a 2 tier system, my understanding of where to place the DLL is dependant on where the code is run. I.e. if the code is set to run on the server, then the DLL should

RE: [development-axapta] AxaptaCOMConnector using incorrect Company/DataAreaID

2006-03-16 Thread Bayliss, Barry
Hello, Modify your Axapta code to be of the nature changeCompany(xxx) { code you want to run } Barry. -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of philwallker Sent: Friday, 17 March 2006 1:19 AM To:

RE: [development-axapta] Merging the different Addons

2006-03-05 Thread Bayliss, Barry
Asm_73, Are you able to get the addon's as XPOs instead of AOD files? The reason I ask is that this will save a lot of problems (as far as I see). Your biggest problem will be merging the code if the same objects are modified in both addons. Barry. -Original Message- From:

RE: [development-axapta] Lock a purchase order for another buyer

2006-03-01 Thread Bayliss, Barry
Nicolas, I end up implementing something very similar. What I end up doing was create the lock when the record was modified (using the WRITE method on the form datasource - purchLine). When the user left the record (using the LEAVE method on the form datasource - purchTable) the lock was

RE: [development-axapta] Re: query with or array field

2006-02-09 Thread Bayliss, Barry
Agus, Is there a reason why you are trying to do this using the Query structure? Why not use While Select ProdTable Where (ProdTable.dimension[1] == 'Admin' || ProdTable.dimension[2] == 'fina') { . } Barry. -Original Message- From: development-axapta@yahoogroups.com

RE: [development-axapta] Re: Resorting a table buffer

2006-01-27 Thread Bayliss, Barry
Christoph, Why do you not want to use another table buffer? Why not modify the code as follows? While Select CT Order by Name { Print CT.AccountNum; } Pause; Barry. -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of

RE: SV: SV: [development-axapta] Joining 2 tables gives no result

2006-01-27 Thread Bayliss, Barry
Thomas, Two things. 1. Do you have a journal number XXX in the LedgerJournalTrans table? In our system, the JournalNum field is right justified, ie the field is padded with spaces. So your where condition would be Lt.JournalNum like %XXX. 2. There is no field Vend field in the

RE: [development-axapta] Performance Issue

2006-01-23 Thread Bayliss, Barry
Maverick, In response to your questions/points made 1. The only way to guarantee the recIDs will be in sequential order is for you to be running the only process on the system at the time the information is stored. If someone inserts a record into another table while your process is

RE: [development-axapta] Development IV

2006-01-23 Thread Bayliss, Barry
Gary, Not too sure what the other methods you tried are. The solution is to change the declaration line of strItemId to make it finite in length. This can be done by making it SalesIdBase strItemID Or Str 22 strItemID (the number 22 can be replaced the appropriate length used by your

RE: [development-axapta] Development IV

2006-01-23 Thread Bayliss, Barry
In Axapta 3 sp2, the extended data type of salesTable.SalesId is SalesIdBase. The definitions of the extended data types in sp2 are: ItemId str 20 SalesIdBase str 22. If you use ItemId in the definition, you may have problems if your salesId ever exceeds 20 characters. I would

RE: [development-axapta] Performance Issue

2006-01-10 Thread Bayliss, Barry
Message - From: Bayliss, Barry To: development-axapta@yahoogroups.com Sent: Monday, January 09, 2006 4:18 AM Subject: RE: [development-axapta] Performance Issue Maverick, Thanks for the first piece of code, now for the rest. What are the declarations of Stable1, Stable2, Stable3

RE: [development-axapta] Performance Issue

2006-01-08 Thread Bayliss, Barry
for select case for every condition will be good or going the way it is , is good? Maverick - Original Message - From: Bayliss, Barry To: development-axapta@yahoogroups.com Sent: Friday, January 06, 2006 3:39 AM Subject: RE: [development-axapta] Performance Issue Maverick, Can

RE: [development-axapta] Performance Issue

2006-01-05 Thread Bayliss, Barry
Maverick, Can you post the concerned piece of code? Barry. -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Maverick Sent: Thursday, 5 January 2006 3:55 PM To: development-axapta@yahoogroups.com Subject: Re: [development-axapta]

RE: RE : RE : [development-axapta] Reset position in a tablebuffer

2005-12-22 Thread Bayliss, Barry
@yahoogroups.com, Bayliss, Barry [EMAIL PROTECTED] wrote: Hello Steeve, Can you post the code you used to test, as I found the following: Using the next method: 2:27.002 Using the while method: 2:27.010 Using the query method: 5:04.052 The number of records in the table

RE: RE : RE : [development-axapta] Reset position in a tablebuffer

2005-12-21 Thread Bayliss, Barry
Hello Steeve, Can you post the code you used to test, as I found the following: Using the next method: 2:27.002 Using the while method: 2:27.010 Using the query method: 5:04.052 The number of records in the table was: 59071 The code I used was: static void Job231(Args _args) { Query

RE: [development-axapta] Opening a form

2005-12-20 Thread Bayliss, Barry
Hello Manoj and Shruti, While the code kindly supplied by Shruti will work, I would recommend using the MenuFunction call instead. Ie Args Args = new Args(); MenuFunction MenuFunction; ; MenuFunction = new MenuFunction(MenuItemDisplayStr(), MenuItemType:: ); Args.Record( ...);

RE: SV: [development-axapta] Query to 'OR' two ranges

2005-12-07 Thread Bayliss, Barry
Regards Andrew Jones --- In development-axapta@yahoogroups.com, Bayliss, Barry [EMAIL PROTECTED] wrote: While the following works for fixed values, has anyone managed to make this work with wildcards (Each time I've tried, I received an error 'Query extended range failure: Right

RE: SV: [development-axapta] Query to 'OR' two ranges

2005-12-05 Thread Bayliss, Barry
While the following works for fixed values, has anyone managed to make this work with wildcards (Each time I've tried, I received an error 'Query extended range failure: Right parenthesis expected ...') Barry. -Original Message- From: development-axapta@yahoogroups.com

RE: [development-axapta] Random number

2005-12-04 Thread Bayliss, Barry
Hello Morten, Have a look at the RandomGenerate class. Barry. -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of mlefoa Sent: Sunday, 4 December 2005 8:35 PM To: development-axapta@yahoogroups.com Subject: [development-axapta]

RE: [development-axapta] update field

2005-11-24 Thread Bayliss, Barry
Hello, If you want to recalculate the value when a new record is selected, one way of doing this is to place the call to the calculation in the ACTIVE method of the datasource concerned. If this is not what you are referring to, please give a more detailed explanation of how you have tried

[development-axapta] Forms

2005-09-23 Thread Bayliss, Barry
Hello, I have a couple of quick questions. 1. 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? 2. When control is transferred between forms, i.e. the user selects another form, is

RE: [development-axapta] Cost Center field

2005-07-14 Thread Bayliss, Barry
The extended data type you are looking for is dimension. You need to look at the array elements of the extended data type. Barry. -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of leganchris Sent: Wednesday, 13 July 2005 12:35 AM

RE: [development-axapta] Long Query time

2005-06-28 Thread Bayliss, Barry
Hello Raal, If this is still a problem, please send me a copy of the code concerned. Barry. -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Raal Goff Sent: Thursday, 23 June 2005 4:20 PM To: development-axapta@yahoogroups.com

RE: [development-axapta] @ABC160 error

2005-06-17 Thread Bayliss, Barry
Hello Icham, To me this appears (@ABC160) to be a user defined label. One way to find out the meaning of the label is to use the Label log. This is found on the menu under: Tools Development tools Label Label log If there is no information there, it is possible that objects

[development-axapta] Understanding crash logs

2005-05-13 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

RE: [development-axapta] Re: Label Not coming on a programmable section

2005-04-26 Thread Bayliss, Barry
Many thanks Barry, thats exactly what I forgot to do Regards, John Chircop. --- In development-axapta@yahoogroups.com, Bayliss, Barry [EMAIL PROTECTED] wrote: Did you use element.executeControlColumnHeadings(section identifier) ? -Original Message- From: development-axapta

RE: [development-axapta] Re: Label Not coming on a programmable section

2005-04-24 Thread Bayliss, Barry
Did you use element.executeControlColumnHeadings(section identifier) ? -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of jpchircop Sent: Thursday, 21 April 2005 11:52 PM To: development-axapta@yahoogroups.com Subject:

RE: RE : [development-axapta] inventtableModule doesn't refresh on inventtable when i rename itemid

2005-04-20 Thread Bayliss, Barry
Did you use the Rename function as part of the record info screen? -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steeve Gilbert Sent: Tuesday, 19 April 2005 10:11 PM To: development-axapta@yahoogroups.com Subject: RE :

RE: [development-axapta] Re: Text Case

2005-03-14 Thread Bayliss, Barry
The Axapta equivalent of UCase and Lcase are strupr and strlwr. Barry -Original Message- From: Luis Guilherme [mailto:[EMAIL PROTECTED] Sent: Monday, 14 March 2005 9:25 PM To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] Re: Text Case Hi, sorry I

RE: [development-axapta] Re: What is the BEST practice using Class with Sql Statement

2005-02-28 Thread Bayliss, Barry
Hello, In the group by use just field name, and not table name.field name Barry. -Original Message- From: pepejeans2k [mailto:[EMAIL PROTECTED] Sent: Friday, 25 February 2005 6:16 PM To: development-axapta@yahoogroups.com Subject: [development-axapta] Re: What is the BEST

RE: [development-axapta] Dynamic form changes possible?

2005-02-25 Thread Bayliss, Barry
Hello James, >From your original description of what you are trying to do, the sysSetupFormRun class is unable to do what you want. As you want the effect to be record based, you need to use the active() method on the datasource. Alternatively, you can use a lower level call. By

[development-axapta] Programmatically removing controls from a form

2004-10-28 Thread Bayliss, Barry
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 luck. Can anyone tell me exactly what the CUT() method is

RE: RE : RE : [development-axapta] deleting controls on a form

2004-10-27 Thread Bayliss, Barry
A way to determine the control type is as follows private void ProcessButtonPress ( FormControl Control ) { ; if (Control) { switch (Control.handle()) { case ClassNum(FormButtonControl): Break; Default: Break; } } } -Original Message- From: Jens Fudge

[development-axapta] Colour within a tree controller

2004-09-01 Thread Bayliss, Barry
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 or BIGmate Monitoring Services Pty Ltd (the

[development-axapta] Colour within a tree controller

2004-09-01 Thread Bayliss, Barry
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 or BIGmate Monitoring Services Pty Ltd (the