Re: [Axapta-Knowledge-Village]

[Varden Morris]

Hi Rocco
 
I think you need to select the record for update first. I am not sure what you intend to achieve with the following line:
 
custtable.AccountNum = Projinvoicetable.InvoiceAccount;
 
My guess is to replace this line with the following:
 
Select forupdate Projinvoicetable where Projinvoicetable.InvoiceAccount == custtable.AccountNum; 
 
Varden Morris
 
J. Wray & Nephew Ltd. - Group I.S.
234 Spanish Town Road
Kingston 11, Jamaica, W.I.
 
Phone:  (876) - 923 - 6141 Ext. 2226Fax:      (876) - 923 - 5372 
Cell:      (876) - 3833566Email:   [EMAIL PROTECTED]
            [EMAIL PROTECTED]   Rocco Giumelli <[EMAIL PROTECTED]> wrote:


Hi All
 
I am Trying  to put some code in that will change a Field on a Different table when the change on the custtable  field is Modified
 
Custtable form\Datatsource\custtable\field\blocked ( this is a enum custvendorblocked)
 
Change New Field on Invoiceprojecttable  (A tick Box)
It Can not edit a record as the record has never been selected
 
Missing something????
 
Thanking you all
public void modified(){    ProjInvoiceTable        Projinvoicetable;    CustVendorblocked       Blocked;
 
    super();
 
    custtable.AccountNum = Projinvoicetable.InvoiceAccount;
 
    if(custTable.Blocked  == CustVendorBlocked::All)    Projinvoicetable.ECL_Blocked = Noyes::Yes;    Projinvoicetable.doUpdate();
 
    If(custtable.Blocked ==  CustVendorBlocked::Invoice)    Projinvoicetable.ECL_Blocked = Noyes::Yes;    Projinvoicetable.doUpdate();
 
    If(custtable.Blocked ==  CustVendorBlocked::No)    Projinvoicetable.ECL_Blocked = Noyes::No;    Projinvoicetable.doUpdate();
 
    Projinvoicetable.doUpdate();    custTable_ds.refresh();
 
 }
 
 
 




 

____________________________________________Rocco Giumelli
IT MANAGER       
Metric Australia Pty Ltd
Assistance is only the Beginning 
893745331
 Sharing the knowledge on Axapta. 
		Do you Yahoo!? 
Yahoo! Search presents - Jib Jab's 'Second Term'


Sharing the knowledge on Axapta.








Yahoo! Groups Sponsor


ADVERTISEMENT
<noscript><a href="http://us.ard.yahoo.com/SIG=129ed26vb/M=298184.6018725.7038619.3001176/D=groups/S=1705001380:HM/EXP=1108214059/A=2532114/R=2/SIG=12k8c4b0b/*http://clk.atdmt.com/NFX/go/yhxxxnfx0020000014nfx/direct/01/&time=1108127659207904" target="_blank"><img border="0" src="" /></a></noscript>












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.