RE: [Axapta-Knowledge-Village] Cursor not on record after Summary update

Mon, 14 Nov 2005 04:06:00 -0800

The main problem seems to be the executeQuery code block. Why do you want to run executeQuery, because it will always take you to last record. If you follow the same rereadlines and research, i think you will not even require to use the findRecord method as Harry suggested......

James Flavell <[EMAIL PROTECTED]> wrote:
Hi Harry,
 
Thanks for theis code (hope you can remember it)
 
It seems the users have told me they were getting out of memory error once this code was put into the system (on both sales and purchase side).
Any ideas what might be wrong?
 
Thanks
James
 
 
-----Original Message-----
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Harry (Harshawardhan Deshpande
Sent: 22 September 2005 21:32
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] Cursor not on record after Summary update

hi
 
change the clicked method of   ButtonHeaderUpdateNow (on purchtable form) as follows
 
void  clicked()
{
    PurchTable  purchTableCurrent;
    ;
    purchTableCurrent.data(purchTable);
    purchTable.checkMarkupTrans();
    purchTableForm.enableUpdateJournalButtons(purchTable,
                                              buttonUpdatePurchaseOrder,
                                              buttonUpdateReceiptsList,
                                              buttonUpdatePackingSlip,
                                              buttonUpdateInvoice);
    super();
    purchTable_ds.findRecord(purchTableCurrent);
    purchTable = purchTable;
}
regards
 
harry


James Flavell <[EMAIL PROTECTED]> wrote:
Hi I have a customer using the summary update funciton on both SO and PO and
I just realised that after posting SO or PO of any kind the cursor does not
stay on the record the user had highlighted before they pressed the posting
button.  Instead the cursor goes to the last recod in the SO or PO list!!!!

I found one bit of code that maybe is affecting in
Classes/PurchFormLetter/main:

           if (PurchTable::exist(purchTable.purchId))
            {
                if (purchFormLetter.sumBy()             !=
AccountOrder::None  ||
                    purchFormLetter.numberOfRecords()    > 1)
                {
                    purchTable_ds.executeQuery();
                }
                else
                {
                    purchTable_ds.reRead();
                    purchTable_ds.reFresh();
                    purchTable_ds.editPurch();
                    purchTable_ds.reReadLines();
                }
            }
            else
            {
                purchTable_ds.reSearch();
            }

Can anyone tell me if I change so that the purchtable_ds.executequery() is
replaced by the same code in the else part (reread,refresh) will this work?

I am afraid that this code is actually the part selecting which PO and lines
to include in the posting and not just the refresh

If this is not the right code to change can anyone tell me how to get the
cursor to stay on the same record once the posting is finished.

Thanks
James


Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.

Yahoo! FareChase - Search multiple travel sites in one click.

Sharing the knowledge on Axapta.


YAHOO! GROUPS LINKS



Reply via email to