SQL server select from a varchar or text data type is easy and fast.
I have 9 years of EDI inbound orders and outbound invoices that I can pound through in no time at all. When I limit the search to the past few weeks it is under a second to find a PO#
select * from EDIReceive where edistring like '%OILWAR004%' and dtmAdded >='06-01-2018'
The string could be 4000-16000 characters long depending on how many POs are in a single envelope.
On Wed, Aug 1, 2018 at 9:46 AM Dave Crozier DCrozier@flexipol.co.uk wrote:
Alan, I posted a few messages about it some time ago (few years!) and I did manager to track down the author Jim Korenthal Who did say he would be amenable to releasing the product as open source but I never heard anything more from him unfortunately.
I used it with VFP9 without any problems single user but it fell over when used in a multi-user environment.
Bear in mind there isn't much of its functionality you can't do (if not everything) using M$ SQL Express if you tie in the text search options. I would certainly go this way for onward support, unless of course you track down Jim!
Dave
-----Original Message----- From: ProFox profox-bounces@leafe.com On Behalf Of Alan Bourke Sent: 01 August 2018 11:31 To: profoxtech@leafe.com Subject: Optimised search of memo data.
Back in the olden days I believe there was a tool called PhdBase which enabled quick or quick-ish searching of text data in memo fields. This product appears to not be available any more. Can anyone recommend an alternative? Thx
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]