RE: [development-axapta] [urgent] purchline and inventtrans

2004-12-22 Thread Harry Deshpande
Hi Take the existing purchline, copy the data to a buffer. Call for oldpurchline.delete(), then copy the buffer to new purchline, change purchid and then call newpurchline.insert(). Regards harry   _  From: Cenk Ince [mailto:[EMAIL PROTECTED] Sent: Wednesday, 22 December

RE: [development-axapta] Two layer customizing

2004-12-22 Thread Harry Deshpande
Hi U may have disabled advanced form customisation key found in administration group (configuration) Regards Harry   _  From: Joy [mailto:[EMAIL PROTECTED] Sent: Wednesday, 22 December 2004 5:11 p.m. To: development-axapta@yahoogroups.com Subject: [development-axapta]

[development-axapta] Re: Problem with ax 2.5 to 3.0 data upgrade

2004-12-22 Thread el8tion
--- In development-axapta@yahoogroups.com, [EMAIL PROTECTED] wrote: > > Hi, > the error is in class InventMov_Sales\new - line 9 > super - calls InventMovement > So recompile InventMov_Sales and try again. > A good idea is to compile forward the class InventMovement >  > Otto Wow, thanks f

[development-axapta] Re: What does FormDatasource.write do?

2004-12-22 Thread maipian_chen
Yeah, I found the _ds.write() will insert record in the DB just from the result too.The help documentation is so limited.From where can I look up these functions?Or just I can't see something valuable to explain the method because of the license? --- In development-axapta@yahoogroups.com,

[development-axapta] Re: Item Type BOM not available

2004-12-22 Thread gonzalo_edo
Hi! You probably have disable some license codes, better check it. Take a look at Menu Administrarion -> Setup -> Configuration Regards. Gonzalo --- In development-axapta@yahoogroups.com, "RHODPR" <[EMAIL PROTECTED]> wrote: > > > I have another strange thing : When I insert a new

[development-axapta] Re: Why can't I execute the SQL statement under axapta's table?

2004-12-22 Thread maipian_chen
Yes, I  made a mistake.But I can only say two point: 1, I learn Axapta for just half a year ,and I don't learn it very well. 2. The "standard sql style"statement "Select * from inventtable" under axapta table led me to a wrong way. And I didn't recognize that before. :) --- In developmen

[development-axapta] Re: Why can't I execute the SQL statement under axapta's table?

2004-12-22 Thread maipian_chen
Yes, you are right. Thanks --- In development-axapta@yahoogroups.com, "ozzage" <[EMAIL PROTECTED]> wrote: > > > You certainly can, you just need to figure out the differences > between "X++ SQL" and "normal SQL". > > Please check out the Developers Guide inside Axapta, and look through

RE: [development-axapta] What does FormDatasource.write do?

2004-12-22 Thread Jesper Kehlet
It essentially just executes the write() method on the data source (which you may or may not have overriden), and then updates the record in the database. From: maipian_chen [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 2:40 AM To: developmen

RE: [development-axapta] Missing cluse forUpdate methods of CustPaymReconciliationImport

2004-12-22 Thread Jesper Kehlet
You may find something like "ledgerJournalTrans.selectForUpdate();" which is in e.g. the find() method on the LedgerJournalTrans table. From: matiazo [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 21, 2004 5:06 PM To: development-axapta@yahoogroups.com S

RE: [development-axapta] Problem with ax 2.5 to 3.0 data upgrade

2004-12-22 Thread Bruno Max Sørensen
Have you tried to delete the aoi file? Regards   _  From: el8tion [mailto:[EMAIL PROTECTED] Sent: 21. december 2004 22:08 To: development-axapta@yahoogroups.com Subject: [development-axapta] Problem with ax 2.5 to 3.0 data upgrade I'm back again - same problem. Posted before but

RE: [development-axapta] Re: Why can't I execute the SQL statement under axapta's table?

2004-12-22 Thread Preston A. Larimer
You have to understand that SQL statement in x++ are not true ANSI SQL, nor are they Transact-SQL, Axapta has it's own syntax s.  Here is a couple of examples sql Select * from inventTable x++ Select inventTable Sql Select count(*) from inventTable; x++ select count(recID) fr

[development-axapta] Re: Why can't I execute the SQL statement under axapta's table?

2004-12-22 Thread ozzage
You certainly can, you just need to figure out the differences between "X++ SQL" and "normal SQL". Please check out the Developers Guide inside Axapta, and look through some of the standard application code for examples. For your two specific problems, try: 1.  select count(RecId) from

[development-axapta] Re: How to read temporary table ?

2004-12-22 Thread ozzage
This way works well, but it is difficult to use for a 'while select' loop, unless you are putting all of your "inside-loop" processing logic in the string as well to pass to the runbuf(). Plus it gives you no compile-time checking (although I see your way using xppCompiler partly solves

[development-axapta] Re: Why can't I execute the SQL statement under axapta's table?

2004-12-22 Thread maipian_chen
Thank you very much.You do the right answer.Now I know,SQL of axapta style can run here. --- In development-axapta@yahoogroups.com, "Andrae, Tobias" <[EMAIL PROTECTED]> wrote: > > Read the Axapta Development Handbook (find it under Help in your Ax. client) > Merry Christmas, Tobias > >

AW: [development-axapta] Re: Why can't I execute the SQL statemen t under axapta's table?

2004-12-22 Thread oka
Take care to the syntax! You have to type == instaid of = (X++ ) Otto -Ursprüngliche Nachricht- Von: maipian_chen [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 22. Dezember 2004 12:53 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Re: Why can't I execute the S

[development-axapta] Re: Why can't I execute the SQL statement under axapta's table?

2004-12-22 Thread maipian_chen
   Sorry, my axapta is version 3.0 with sp1.And I just can't execute even "select count(*) from inventtable;"! I can't execute statement like "SELECT itemid,itemname FROM InventTable where inventtable.itemid = 'WL-2500';" either(standard appl.). I don't know why.Seems I can use only "sel

[development-axapta] Re: accesing information in a buffer

2004-12-22 Thread Matrish Mangal
Hello Miguel,    If u want to take value of some field from buffer then u just have to find the table which is contained in Buffer . it can be done by help of tableid field  of buffer. After that assign the buffer to a instance of that table after that u can find value of that record.   

[development-axapta] Two layer customizing

2004-12-22 Thread Joy
Hi all, I want to ask a question about programming in two layer (Var and USR) Now i'm in a axapta project. My team make some program in USR layer and our consultant make it in VAR layer. My team made the program in different axapta application with our consultant. Is there the best way to c

SV: [development-axapta] Context Menu: Go to main table

2004-12-22 Thread Lars Holm
Edit the showcontextmenu method of the control and add the go to main table thingie yourself. Search for showcontextmenu in the forms in the aot and you'll find many examples on how to do that. Br, Lars Fra: smeagul2303 [mailto:[EMAIL PROTECTED] Send

[development-axapta] Context Menu: Go to main table

2004-12-22 Thread smeagul2303
Hello, I wnat to show ItemId from InventTable in a FormTableControl. The behaviour should be the same as in a Grid. Now I have a problem with the context menu option "Go To main Table". It will not be displayed. If I fill in the property from StringEditControl (Itemid) the datasource Inven

SV: [development-axapta] Item Type BOM not available

2004-12-22 Thread Lars Holm
enable the configuration key in logistics called Bills of material. Br, Lars Fra: RHODPR [mailto:[EMAIL PROTECTED] Sendt: on 22-12-2004 10:31 Til: development-axapta@yahoogroups.com Emne: [development-axapta] Item Type BOM not available I have anot

[development-axapta] Re: Why can't I execute the SQL statement under axapta's table?

2004-12-22 Thread Agus Riyadi
You can, the syntax is slightly different with x++ and we can not make a join here. To select specific fields, just type the field name instead of *. The where clause need tablename.fieldname. You can also type aggregate statements here. regards, agus [EMAIL PROTECTED] --- In developmen

[development-axapta] Item Type BOM not available

2004-12-22 Thread RHODPR
I have another strange thing : When I insert a new item in Inventory Management --> Items, there are only two options in the ItemType Combobox : Item and Service. Why can't I select the 'BOM' type? Also, I don't have all the buttons : The BOM and Forecasting buttons aren't there, and the Ro

AW: [development-axapta] Why can't I execute the SQL statement under axapta's table?

2004-12-22 Thread Andrae, Tobias
Read the Axapta Development Handbook (find it under Help in your Ax. client) Merry Christmas, Tobias   -UrsprÃngliche Nachricht-   Von: maipian_chen [mailto:[EMAIL PROTECTED]   Gesendet: Mi 22.12.2004 03:05   An: development-axapta@yahoogroups.com   Cc:

[development-axapta] Two layer customizing

2004-12-22 Thread Joy
- Original Message - From: Joy To: development-axapta@yahoogroups.com Sent: Wednesday, December 22, 2004 11:11 AM Subject: Two layer customizing Hi all, I want to ask a question about programming in two layer (Var and USR) Now i'm in a axapta project. My team make some program

RE: [development-axapta] Problem with ax 2.5 to 3.0 data upgrade

2004-12-22 Thread Preston A. Larimer
Both inventmov_sales and inventMovement have new methods in the sys layer, if your not seeing them you might have either a corrupt sys.aod file, a bad aoi file, or have mods in outer layers blocking the standard code.  Try doing a compare on these classes and see if you can tell any differenc

AW: [development-axapta] Problem with ax 2.5 to 3.0 data upgrade

2004-12-22 Thread oka
Hi, the error is in class InventMov_Sales\new - line 9 super - calls InventMovement So recompile InventMov_Sales and try again. A good idea is to compile forward the class InventMovement Otto -Ursprüngliche Nachricht- Von: el8tion [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 21. D

[development-axapta] form setup disabled

2004-12-22 Thread RHODPR
I've just done a new installation of Axapta, and when I wanted to setup a form (on form right-click, select setup), the buttons at the bottom ('up', 'left', 'right', 'down', and 'add fields', 'remove') are all disabled (greyed out).  How can I enable them? Yahoo! Groups Spo

[development-axapta] [urgent] purchline and inventtrans

2004-12-22 Thread Cenk Ince
Hi all; I want to change purchid of a purchline with purchline.initFromPurchTable(newPurchTable); But in inventTrans table there is a reference for purchTable, Is it good, me to update inventtrans or is there another way to do this. Thanks [Non-text portions of this message have been

Re: SV: [development-axapta] Axapd.aoi file error

2004-12-22 Thread jasondykeson
Dear all, It was the damn attributes of tha oad file AND the disk space. Wel it is now solved Thanx to every one Jason D. --- In development-axapta@yahoogroups.com, "Stefan Lundquist (Priv)" <[EMAIL PROTECTED]> wrote: > > Hi, > Maybe you are out of diskspace? Virtual memory ? > Is

RE: [development-axapta] Axapd.aoi file error

2004-12-22 Thread Jason Dykeson
The disk space and the damn attributes were the problem. Now it is solved. Regards, Jason D. -Oorspronkelijk bericht- Van: Stefan Lundquist (Priv) [mailto:[EMAIL PROTECTED] Verzonden: dinsdag 21 december 2004 18:37 Aan: development-axapta@yahoogroups.com Onderwerp: SV: [developmen

[development-axapta] What does FormDatasource.write do?

2004-12-22 Thread maipian_chen
I can't get anything valueable from AOT documentation and Online Help.Thanks. Yahoo! Groups Sponsor Get unlimited calls to U.S./Canada Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/  To unsubscr

[development-axapta] Why can't I execute the SQL statement under axapta's table?

2004-12-22 Thread maipian_chen
Seems only "select * from tablename " is usable.How about other statements? Thanks. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/  To unsubscribe from this group,