David SET VAR vBALANCE CURRENCY = NULL
SELECT balance into vBALANCE INDI isNULL FROM YourTableName where count = last The Select will load the variable vBALANCE with the balance of the last row entered. John From: [email protected] [mailto:[email protected]] On Behalf Of DAVID Sent: Sunday, August 09, 2009 8:18 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: ROW UPDATE John, The data is entered as custid datepaid debit credit balance 1 8/23/2009 10.00 is there a way to look back at the last balance and then show a new balance David On 8/9/09, John Engwer <[email protected]> wrote: David, The simple answer to your question is yes but the technique for doing so will vary depending on how you have your data structured. For instance, in one of my vertical applications I have a check book. It is not uncommon for checks or deposits to be entered out of date sequence which dictates that you have to adjust the balance based on the date of the transaction rather than the date of the last entry. In that case it is not a simple process of updating a balance of data that is always entered sequentially. Describe how your data is laid out, what you are trying to accomplish and we may be able to offer some suggestions. John From: [email protected] [mailto:[email protected]] On Behalf Of DAVID Sent: Sunday, August 09, 2009 2:51 PM To: RBASE-L Mailing List Subject: [RBASE-L] - ROW UPDATE IS THERE A WAY TO UPDATE A ROW BALANCE AFTER ADDING A DEBIT OR CREDIT BY USING A BALANCE FROM A PREVIOUS ROW DAVID
