RE: Optimised search of memo data.

Oops... never sent a link:

http://www.tributes.com/obituary/show/James-Korenthal-91427622

His age would seem to be correct but it may well be someone else, in which case apologies.

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.