RE: Optimised search of memo data.

It would seem that Jim has passed away according to my searches. I know he had movd to New York prior to my last communication and my searches gave up this:

Dave Crozier Software Development Manager Flexipol Packaging Ltd.

-----Original Message----- From: ProFox profox-bounces@leafe.com On Behalf Of Alan Bourke Sent: 01 August 2018 16:05 To: profoxtech@leafe.com Subject: Re: Optimised search of memo data.

I was considering a simple MSSQL table with an nvharchar(max) field to hold the VFP memo contents, and full-text indexing on it. Then it is just a question of querying that from VFP, and refreshing the records in it from VFP on some sort of timed basis.