Ted, You are correct in that saying. I still have a couple of applications in VFP9 running PHDBase and they have been working unattended for about 10 years without issues.

I do remember a couple of issues when I set it up but the notes aren't available without much searching of the archives! I will take a look though.

Dave Crozier Software Development Manager Flexipol Packaging Ltd.

﴾⚆ᨎ⚆﴿

Flexipol® Packaging Ltd T 01706 222 792 E DCrozier@flexipol.co.uk W https://www.flexipol.co.uk/ Follow us: Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden, Lancashire, BB4 5HH

​This communication and the information it contains is intended for the person or organisation to whom it is addressed. Its contents are confidential and may be protected in law. If you have received this e-mail in error you must not copy, distribute or take any action in reliance on it. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.

Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the risk of virus transmission through email and therefore any files sent via e-mail will have been checked for known viruses. However, you are advised to run your own virus check before opening any attachments received as Flexipol Packaging Ltd will not in any event accept any liability whatsoever once an e-mail and/or any attachment is received.

It is the responsibility of the recipient to ensure that they have adequate virus protection.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ​​ ​Terms & Conditions: Notwithstanding delivery and the passing of risk in the goods, the property in the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. ("The Company") has received in cash or cleared funds payment in full of the price of the goods and all other goods agreed to be sold by the seller to the buyer for which payment is then due. Until such time as the property in the goods passes to the buyer, the buyer shall hold the goods as the seller's fiduciary agent and bailee and keep the goods separate from those of the buyer and third parties and properly stored protected and insured and identified as the seller's property but shall be entitled to resell or use the goods in the ordinary course of its business. Until such time as the property in the goods passes to the buyer the seller shall be entitled at any time -----Original Message----- From: ProFox profox-bounces@leafe.com On Behalf Of Ted Roche Sent: 13 October 2020 19:35 To: profox@leafe.com Subject: Re: phdbase

https://fox.wikis.com/wc.dll?Wiki~PhdBase~VB and searching the ProFox archives: https://leafe.com/archives

might give you some clues. Dave Crozier claims it works with VFP9 (see the wiki)

On Tue, Oct 13, 2020 at 1:58 PM Rafael Copquin rafael.copquin@gmail.com wrote:

Hi guys, it's been e long time!

I just inherited an old vfp5 program that needs to be updated to VFP9, adding new routines to enhance performance and migrate the dbf's to sql server.

I encountered some dbfs that have an additional file with a phd extension which I believe is generated by a program that facilitates text searches in memo files.

I try to open the dbf but vfp9 says that it can't find the phd file, even though the dbf, its cdx and phd files are in the same folder.

I tried to set tablevalidate to 0, set exclusive on but to no avail

How can I open those dbf's?

TIA

Rafael Copquin

--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html

---

[excessive quoting removed by server]

As a quick note, I managed to track Jim down just before his demise and we were chatting about him possibly releasing the source code to phDBase to be open source.

Unfortunately events overtook the discussions and I haven't been able to track down anyone who has access to the product. In it's day it was a great took for any type of free text searching for .dbf files.

Rafael, I still have a copy of the product if it would help you in your investigations.

Dave Crozier Software Development Manager Flexipol Packaging Ltd.

﴾⚆ᨎ⚆﴿

Dave Crozier Software Development Manager Flexipol Packaging Ltd.

Mob: 07967 671080

﴾⚆ᨎ⚆﴿

Flexipol® Packaging Ltd T 01706 222 792 E DCrozier@flexipol.co.uk W https://www.flexipol.co.uk/ Follow us: Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden, Lancashire, BB4 5HH

​This communication and the information it contains is intended for the person or organisation to whom it is addressed. Its contents are confidential and may be protected in law. If you have received this e-mail in error you must not copy, distribute or take any action in reliance on it. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.

Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the risk of virus transmission through email and therefore any files sent via e-mail will have been checked for known viruses. However, you are advised to run your own virus check before opening any attachments received as Flexipol Packaging Ltd will not in any event accept any liability whatsoever once an e-mail and/or any attachment is received.

It is the responsibility of the recipient to ensure that they have adequate virus protection.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ​​ ​Terms & Conditions: Notwithstanding delivery and the passing of risk in the goods, the property in the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. ("The Company") has received in cash or cleared funds payment in full of the price of the goods and all other goods agreed to be sold by the seller to the buyer for which payment is then due. Until such time as the property in the goods passes to the buyer, the buyer shall hold the goods as the seller's fiduciary agent and bailee and keep the goods separate from those of the buyer and third parties and properly stored protected and insured and identified as the seller's property but shall be entitled to resell or use the goods in the ordinary course of its business. Until such time as the property in the goods passes to the buyer the seller shall be entitled at any time -----Original Message----- From: ProFox profox-bounces@leafe.com On Behalf Of Jürgen Wondzinski Sent: 14 October 2020 08:28 To: 'ProFox Email List' profox@leafe.com Subject: AW: phdbase

Hmm... If you deleted the CDX, then the call to the PHD() function in one of the indexkeys was deleted, thus you don't know how it was indexed anymore. Hopefully you still have a backup :)

BTW: I just verified that the VFP5 libray is working without problems in VFP9.

The author of PHdBase, Jim Korenthal, seems to have died in 2011. Send me a PM if you need the full helpfile. Here's the Quickstart blurb:

+---------------------------------+ ¦ phd: Quick Start ¦ +---------------------------------+

If you're using Visual FoxPro or FoxPro for Windows, copy PHDBASE.BMP to the same directory where you've copied PHDBASE.MSG.

You may want to add one of these to CONFIG.FP and/or CONFIG.FPW:

phdbase language = English (uses default, PHDBASE.MSG) phdbase language = French (uses PHDBASE.FRE file) phdbase language = German (uses PHDBASE.GER file) phdbase language = Spanish (uses PHDBASE.SPA file) phdbase language = Italian (uses PHDBASE.ITA file)

Now start FoxPro and type this in the command window:

set talk on set library to phdbase.fll

Press enter to bring down PhDbase's signon screen. Then type this in the command window:

use phdhelp && the helpfile for the product =phd("index topic, details, numbers, keep all")

You've created a PhDbase full text index on PhDbase's own help file. You only need to create this index once, since PhDbase automatically keeps your indexes up to date as the data changes.

The file PHDHELP.PHD contains the index you've just created. There are only 100 records in PHDHELP.DBF, but for larger files, PhDbase typically creates indexes of less than 1/10th the size of the original data! And if you have a fairly fast computer you've already noticed that PhDbase can index millions of bytes of data per minute.

Let's try a few PhDbase searches. Note that the number of "hits" may vary somewhat depending on your version of the PhDbase help file.

=phd("<<mouse>>") finds and displays 11 records

=phd("<<hypertext>>") finds and displays 13 records

=phd("<<mouse and hypertext>>") <-- a "boolean search" finds and displays 4 records

=phd("<<mouse near hypertext>>") <-- a "proximity search" finds and displays 2 records

=phd("<<like hipretekst>>") <-- a "fuzzy search" finds and displays 13 records

No matter what speed computer you're using, you've noticed that all of these searches are virtually instantaneous!

If you wish, press F1 when any of these searches displays for information on using PhDbase's hypertext system. You can also issue the command =phd("help") at any time to access PhDbase's built-in mini-help feature.

You can get rid of the help file's PhDbase index by typing:

=phd("unindex")

Okay, at this point you should have a feel for what PhDbase III is all about. Note that the PhDbase library must be loaded ("set library to phdbase") before you USE any file which has a PhDbase index. If you forget to load the library, you'll get a message saying "PHD.PRG not found" when you try to USE your file. If you wish to keep a file but no longer use it with PhDbase, please read the section entitled "phd: Removing an Index."

Happy searching!

-----------------------------------

-----Ursprüngliche Nachricht----- Von: ProFox profox-bounces@leafe.com Im Auftrag von Rafael Copquin Gesendet: Dienstag, 13. Oktober 2020 20:52 An: ProFox Email List profox@leafe.com Betreff: Re: phdbase

Hi Woody Thanks for the info. I did as you suggested, but also deleted the cdx and phd files and could open the dbf with no problem. Thanks again Best regards Rafael

[excessive quoting removed by server]