John, Works like a charm you are my hero...........
Thank You, David On 8/10/09, John Engwer <[email protected]> wrote: > > 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 > > > > >
