×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Thanks all, as always very interesting reading.
From Birgitta :
Executing the SQL statement CLOSE will only perform a hard close if the SQL
statement is not reuseable.
What does not reuseable mean ?.
My problem was this:
All clients, companies and people in one client file. 2 LFs : one on the
person's name, one on the company name.
The subfile is cleared and recharged at every pageup or down operation, as a
lot of users are adding and deleting clients all the time.
So if there's a pageup or down requested, the program does SETLL, READE
from the last row on displayed or SETGT READPE from the first row.
Now I've been asked to take into account a search on the client's maiden
name. Normally I would have created a 3rd LF. Unfortunately the procedures
will have to use another parameter and juggle now with 3 LF's.
This 3rd type of search, on the maiden name, would only be asked rarely.
There will be proportionally very few clients in the LF: only married women!
I was just wondering about SQL that's all.
midrange.com
