[development-axapta] 2 notexists in SQL statement

2006-05-22 Thread kamchung322
Hi All, I want to filter out the Production Order which has no record exists in the ProdJournalTable and NWS_ProdJournalTable (table structure same as ProdJournalTable, for temporary store some information). I use the following SQL statement to do it but unsuccessful. It will return the

[development-axapta] Pass variable by reference

2005-11-23 Thread kamchung322
Hi All, Can I pass a variable to a method by reference ? Regards. Kenneth. SPONSORED LINKS Computer part Programming languages

[development-axapta] SQL Statement in QueryBuildDataSource

2005-10-24 Thread kamchung322
Hi All, Anyone know how to assign/edit the sql statment in QueryBuildDataSource ? Regards. Kenneth. YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo!

[development-axapta] Re: Code Estimation Code

2005-09-23 Thread kamchung322
Try the following code : void updateCostEstimation(ProdId prodId) { ProdMultiCostEstimation prodMultiCostEstimation; Args args; ProdParmCostEstimation prodParmCostEstimation; ProdPurch prodPurch; ProdTable prodTable; ; prodTable = ProdTable::Find(prodId); prodMultiCostEstimation =

[development-axapta] Re: Sending email automatically in Axapta

2005-08-22 Thread kamchung322
Hi, Please try to use the sysmailer class. Regards. Kenneth. --- In [EMAIL PROTECTED], Michael Behrens [EMAIL PROTECTED] wrote: Hi, I use Blat for this stuff. http://www.blat.net/ Regards, Michael Huseyin Akdag [EMAIL PROTECTED] wrote: Hi all, I am trying to

[development-axapta] Join datasource with 2 fields

2005-08-22 Thread kamchung322
Hi All, I want to join 2 datasources with 2 fields. Following is the code : QueryBuildDataSource qb; qb = this.query().dataSourceNo(2; qb.addLink(FieldNum(Table1, Field1), FieldNum(Table2, Field1)); qb.addLink(FieldNum(Table1, Field2), FieldNUm(Table2, Field2)); the above code will join

[development-axapta] Find Record by TableId RecId

2005-07-14 Thread kamchung322
Hi All, I want to write an generic program. I pass the tableid, recid and the program will display the Primary Key. ie. When I pass the tableid of ProdTable, it will display the ProdId. When I pass the tableId of InventTable, it will display the ItemId. Is it possible to do it and how to

[development-axapta] Non English Char in Email

2005-07-14 Thread kamchung322
Hi All, I use classes\SysEmailer to send non english email but the char cannot display properly. I have already set the bodyCharSet to GB2312 (Chinese Simplified). Can anyone help me to solve this problem ? Thank you. Kenneth. SPONSORED LINKS

[development-axapta] AOS : user remain online

2005-05-31 Thread kamchung322
Hi All, I have encountered a problem. Some of our users have logoff to the system. But on the online user form, it indicates they still online. It is only happen for the user who using AOS. Regards. Kenneth. Yahoo! Groups Links To visit your group on the web, go

[development-axapta] Count no of record in Join statement

2005-05-25 Thread kamchung322
Hi All Is it possible to count no of record in join statement ? I try the following SQL statement but return error. select count(recId) from purchLine group by (recId) WHERE purchLine.PurchStatus == PurchStatus::BackOrder join PurchPoolId from PurchTable where PurchTable.purchId ==

[development-axapta] Deny user log on concurrently

2005-05-13 Thread kamchung322
Hi, Is it possible to deny user log on concurrently ? Regards Kenneth. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is

[development-axapta] Auto restart AOS server

2005-02-24 Thread kamchung322
Hi, I want to auto restart AOS server as specified time (ie. every sun 12:00am). Is it possible and how to do ? Regards. Kenneth. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go

[development-axapta] Dynamic set data sources field property in form.

2004-12-19 Thread kamchung322
Hi All, Is it possible to dynamic set the data sources field property in form? For example : I want to check if Production order status is not Created, the property Allow edit of QtySched field is set to Yes, otherwise, set to No. Regards. Kenneth. Yahoo! Groups

[development-axapta] Re: Post PurchLine

2004-12-14 Thread kamchung322
(), PurchUpdate::ReceiveNow) Regards Matthias _ Von: kamchung322 [mailto:[EMAIL PROTECTED] Gesendet: Montag, 13. Dezember 2004 13:17 An: [EMAIL PROTECTED] Betreff: [development-axapta] Post PurchLine Hi All, How can I post packing slip for Purch Line by ReceiveNow qty. I know

[development-axapta] Post PurchLine

2004-12-13 Thread kamchung322
Hi All, How can I post packing slip for Purch Line by ReceiveNow qty. I know how to post it by the whole Po. PurchFormLetter _purchFormLetter; PurchTable _purchTable;' _purchTable = PurchTable::Find('PO0001'); _purchFormLetter = purchFormLetter::construct (documentstatus::packingslip,

[development-axapta] Query Dimension

2004-12-05 Thread kamchung322
Hi All, How can I only query Dimension[1] value = 'SubCon'. I try to use the following code but it will filter Dimension[1] = 'SubCon', Dimension [2] = 'SubCon' and Dimension[3] = 'SubCon' this.query().dataSourceNo(2).addRange(FieldNum(ProdBOM, Dimension)).value(QueryValue('SubCon'));

[development-axapta] COM Connector UniCode

2004-11-13 Thread kamchung322
Hi All, I am using Excel VBA COM Connector to retrive save data to axapta. When I retrive a data include Chinese character, it will display a strange character. (Not Chinese character). Did Axapta don't support unicode via COM connector ? How can I solve this problem. I am using

[development-axapta] Re: Build-in SysExcel* Class function not enough

2004-10-23 Thread kamchung322
Thu, 21 Oct 2004 02:40:17 - skrev kamchung322 [EMAIL PROTECTED]: Hi all, I found the function in SysExcel* is not enough. ie. Can't copy the exist sheet in the same file, Can't get the last row/column in the SysExcelRange. How can I modify the extend these functions

[development-axapta] Message Box

2004-09-28 Thread kamchung322
Hi, How can I display a message box ? Something like when you exit the Axapt, it prompt you Are you sure you want to exit MBS-Axapta ? Regards. Kenneth. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go

[development-axapta] Re: Determine records selected in grid

2004-09-10 Thread kamchung322
is: \Data Dictionary\Tables\SalesParmTable\Methods\checkTransferToUpdate() Best regards, Bjørn Møller Pedersen Thy Data Center Development A/S --- In [EMAIL PROTECTED], kamchung322 [EMAIL PROTECTED] wrote: Hi All, How to determine which records (rows) the user selected in grid

[development-axapta] How to get the current logon user information ?

2004-09-10 Thread kamchung322
Hi All, How can I get the current logon user info ? ie. username, userid etc.. Regards. Kenneth. 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

[development-axapta] Determine records selected in grid

2004-09-09 Thread kamchung322
Hi All, How to determine which records (rows) the user selected in grid ? Regards. Kenneth. 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