[development-axapta] Re: User modifications.

2005-06-07 Thread mikaeldalgaard_dk
Hi Jens Strandberg, SysLastValue contains all user modifications stored in Axapta :-) Best regards /Mikael D. --- In development-axapta@yahoogroups.com, Harry Deshpande [EMAIL PROTECTED] wrote: Hi I think it's the syslastvalue table. Regards Harry Jens

[development-axapta] SQL Query

2005-06-07 Thread TANIC55
I try to use the runbuf funtion to generate this query but not successful. Please advised. _SQL = ' Select ProdBom group by itemid where ProdBom.itemid == '+ ''+ _item + ''; _SQL += ' join ProdTable group by CSM_CustomerCode where ProdTable.Prodid == ProdBom.Prodid'; _SQL += ' join

RE: [development-axapta] Query Range

2005-06-07 Thread Lee Yacovett
Thanks, I was trying something similar, but just couldn't get the syntax quite right. Erik Hansen [EMAIL PROTECTED] wrote: Hi, It's possible to write this 'or' in a queryRange. QueryRange = this.Query().DataSourceNo(1).AddRange(fieldNum(prodTable, createdby));

RE: [development-axapta] Query Range

2005-06-07 Thread Lee Yacovett
I trid to use this, but I get an Unable to parse the value error. I figured this was hw to fix this problem, but I can't figure out the syntax. I also tried adding prodtable. before the ranges, but I got the same error. Erik Hansen [EMAIL PROTECTED] wrote:Hi, It's possible to write

[development-axapta] Add new field on InventOnHandItem form

2005-06-07 Thread oscarcaravaca
Hi there, I'm new in Axapta. I would like to add a new column on grid on InventOnHandItem form. The field that i need to show is MinInventOnHand of ReqItemTable. Any ideas on that I have tried to add ReqItemTable datasource on the form and make changes in relations but haven't obtained

[development-axapta] Reservations

2005-06-07 Thread oscarcaravaca
Hi there. We have got a very big problem with reservations/inventory/sales, and we would like to implement a Business politic concerning this topics. 1)Reservation of inventory is going to be done directly by the system weekly (normally on weekend) and reservations will expire in current

[development-axapta] Interview

2005-06-07 Thread Srinivas Chenna
HI friends ! I have interview on AXAPTA (FINANCE). Please help me regarding any FAQ urls or material ,morphix,x++ and axapta material. Can i have information about complite CYCLE of axapta information thanking you oscarcaravaca [EMAIL PROTECTED] wrote: Hi there. We have got a very big

RE : [development-axapta] Query Range

2005-06-07 Thread Steeve Gilbert
Maybe the %1 and %2 need to be quoted. Have you tried that? (((createdBy == \%1\) || (modifiedBy == \%2\)) Steeve... -Message d'origine- De : development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de Lee Yacovett Envoyé : 7 juin 2005 08:50 À :

Re: RE : [development-axapta] Query Range

2005-06-07 Thread Lee Yacovett
Yes, I tried quoting them, I also tried using single quotes and double quotes, but still got the same result. Steeve Gilbert [EMAIL PROTECTED] wrote:Maybe the %1 and %2 need to be quoted. Have you tried that? (((createdBy == \%1\) || (modifiedBy == \%2\)) Steeve... -Message

[development-axapta] Importing a text file

2005-06-07 Thread Zappia Alessandro
Hi everybody! I'd like to create a method to import a text file into a table. The fields in this file has different types of data (int, real, string) and are fixed lenght, with no separators char between the fields. It doesn't seem possible using the read method od an IO class (AsciiIO or