Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!iuvax!silver!tsui From: tsui@silver.bacs.indiana.edu Newsgroups: comp.databases Subject: Re: foxbase problem, need help Message-ID: <20900013@silver> Date: 4 Aug 89 18:37:00 GMT References: <85@csnz.co.nz> Organization: Indiana University CSCI, Bloomington Lines: 26 Nf-ID: #R:csnz.co.nz:-8500:silver:20900013:000:1074 Nf-From: silver.bacs.indiana.edu!tsui Aug 4 13:37:00 1989 /* Written 5:56 pm Aug 3, 1989 by paul@csnz.co.nz in silver:comp.databases */ /* ---------- "foxbase problem, need help" ---------- */ I solved this problem for dBase III in London a few years ago. I still have the source, which I am happy to post to those who would like it. Basically what it does is build a customised procedure by outputting code to a text file, then executing the code. The procedure output by the program consists of a series of tests that cause it to exit with a status flag set to failed unless it gets past the last IF. Since you can't assume that any field is indexed you have to do a sequential search, then call the procedure for each record. ... -- Paul Gillingwater, Computer Sciences of New Zealand Limited Bang: ..!uunet!dsiramd!csnz!paul Domain: paul@csnz.co.nz Call Magic Tower BBS V21/23/22/22bis 24 hrs +0064 4 767 326 /* End of text from silver:comp.databases */ Please! Post it . I think lot of people will encounter this problem unless foxbase can eliminate its limitation. Thanks! --yufeng tsui@silver.bacs.indiana.edu