CompuServe Messages

Philip, I have been useing FoxPro V2.5 to manage a 420 Mb, 490,000 record database of aviation safety data on one-off CDs. I tried Paradox for DOS first but it inflated the files to about twice the size of .DBF files. I have the .DBF and .CDX files on the CD and run FP from the hard disk. Just don't forget to specify a path when writing a file to disk. When I had my CD drive hooked directly to a SCSI card the performance was nearly as good as from the HD, sometimes actually better. I now have my drive hooked to the paralell port on my notebook for portability which slows things up considerably. It's still acceptable though. Some complex searches take awhile from either HD or CD. But it's relatively simple to output a subset to a new file and work on them. My biggest problem now is that the FoxPro Developers Kit does not include the RQBE screen. And because my databases have so many fields and every user wants to do unique searches there is no way that canned searches are adequate. I found a third-party add-on called FoxFire in the FoxForum which can do ad hoc searches, but the license fee is a little pricey for my application. If anyone can tell me how to include the RQBE in a runtime version then FoxPro will be perfect for my CD application. Let me know if you have any questions. Kathy Cochrane at the One-Off Shop Mid-South produces my CDs and I'm sure can answer any questions about that end of the process. Regards, John