David, I assume that you are using a form to enter the data and that the table the form is based on contains the columns that you indicated in your prior post.
You will need to assign a variable that will automatically set to the CustID. To do that, click on "Variables" at the top of the form and add a new variable vCustID = CustID. Then in the appropriate EEP use the following commands: SET VAR vBALANCE CURRENCY = NULL SELECT balance into vBALANCE INDI isNULL FROM YourTableName where CustID = .vCustID and count = last (This is assuming that the last row entered for that CustID has the correct balance) Once you have the last balance stored in vBALANCE you can add the entry new entry to vBALANCE to display the new balance. John From: [email protected] [mailto:[email protected]] On Behalf Of DAVID Sent: Monday, August 10, 2009 8:44 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: ROW UPDATE John, I am sorry that I am not better at explaining what I need. What you gave me works fine to retrieve the last row in the database however I need to get the last balance of a single customer custid=1 or custid=7. I am trying to use this in a form and I added to what you gave me where custid=custid but it did not work. can you help?? Thanks, David On 8/9/09, John Engwer <[email protected]> wrote: 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
