FiveTech Software tech support forums

... to change the type of search. It is instantaneous. Now, because its a browse, each of those columns is shown, so they are not unique. If its Smith on Oak Street, I can put in Smi and see the lists of Smiths. There are not many in a population of 400, or 1000, records. Then I look across to ...

... is included in the xBrowse methods. If he needs to look up Samuel Dobrienskivask, he may find the record in the list with just Dob. However, James Smith will likely require him to input far more. Anyway, that is the way I read the request and how I responded. Tim

... for a minute. The problem seems to be how to find a patient's record. Let's consider this in generalities. Most common last name in the USA is Smith. It is 1 percent of the population. http://names.mongabay.com/most_common_surnames.htm So out of a million records, 1 percent, or 10000 records, ...

Darrell,

cdmmaui wrote:Hello,

I have reinstalled xHarbour and RTL.LIB is missing.

From where do you got xHarbour? It's clearly an incomplete package. Please use the one distributed with FWH. Or use Mel Smith's build: whosaway.com (Password: 'XHB').

EMG

We are doing queries on dbf/cdx files without a dictionary. The only thing to notice is that any condition like "Where Name = 'Smith'" needs an index on Name without a condition Alex Alex; True, you may execute SQL without a DD connection and still take advantage of indexes, but ...

We are doing queries on dbf/cdx files without a dictionary. The only thing to notice is that any condition like "Where Name = 'Smith'" needs an index on Name without a condition The process is basically: #include "ads.ch"Adsconnect("c:\pathtodata")select ...

... provided that you have an index based on field state and field lastname, then sql below is really fast: SELECT * FROM customers WHERE lastname = 'Smith' AND state = 'CA' That statement will return a cursor (like a table) with all the columns on table customers where the customer lastname field ...

... (dynamic) cursors, updates to the base table are reflected in the cursor. For example, consider "select * from employee where lastname = ‘Smith’". If a record is appended to the employee table and the new record’s lastname field is set to ‘Smith’, that new record will be inserted ...

... · • If a memo field is used in a WHERE clause (e.g., WHERE memo is null) · • LIKE operator is used in a WHERE clause (e.g.,. WHERE lastname LIKE 'Smith%) · • Expressions or scalar functions in the select list (e.g., select UCASE(lastname) … ) · • TOP in the SELECT clause · • WHERE clause contains ...

... by specifying character strings which occur anywhere in any of these fields. Given "john," HiPer-SEEK would identify records for John Smith, Elton John, 345 John White Avenue, and Johnson City. Additionally, the application might limit matches to those containing "john" in ...

... different names mapping to the same hash "bucket." See under the "Collision Resolution" section the example that "James Smith" and "Sandra Dee" both map to the same hash number. http://en.wikipedia.org/wiki/Hash_table#Perfect_hash_function So ...

... See listbox .. I want to color each like cell the same BACKGROUND ( not forground is in the example ) color as in LIPKIN LIPKIN LIPKIN JONES JONES SMITH WILSON WILSON http://img709.imageshack.us/img709/1183/xbrowse.jpg I need to test for the contents of each cell and match it to ...

... you use something like this for your Hotel guests ??? Thanks in advance !! Rick Lipkin car Mon Tues Wed Thurs 101 | Rick Lipkin | 102 | Jack Smith |

... increased resource usage on the server. This is especially true if non-optimized filters are created. For example, if the filter "lastname = ‘Smith’" is used and there is no index available on lastname, the filter will not be optimized. This means that every bit will be turned on initially. ...

... example, I have an IsDoctor field which say contains a "D" for a doctor and " " otherwise then to get all doctors named "Smith" I just have to search on "DSMITH" given that I maintain an index on Upper( IsDoctor + Surname). It is an approach I have thought ...