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 > > >
