RE: Optimised search of memo data.

Alan, My further searchings reveal that the Foxweb Full Text search facility may be of use to you:

http://www.foxweb.com/fwFullText/

No idea if it is still supported though.

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.