RE: [RBASE-L] - speeding up searches in a view

2016-06-02 Thread Dan Goldberg
Because when you put the calculation in the command it has to evaluate it for each row. Dan Goldberg From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Michael J. Sinclair Sent: Thursday, June 2, 2016 3:48 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - speeding

[RBASE-L] - speeding up searches in a view

2016-06-02 Thread Michael J. Sinclair
Hi all, I was doing a search of a two table view with about 1 million rows.The column I am using has an index. This search was very slow. BROWSE ALL FROM viewname WHERE columname > (.#date - 365) This search was almost instant SET VAR vdate = (.#date - 365)BROWSE ALL FROM viewname WHERE

Re: [RBASE-L] - I need to redefine a function key.

2016-06-02 Thread A. Razzak Memon
At 09:44 AM 6/1/2016, Hodges, Dennis wrote: The F9 key is a delete. It deletes and places the focus on the previous record. I want to delete and place focus on the next record. There are occasions in my application that several records need to be deleted and this would reduce the steps