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 <[email protected]> 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 <[email protected]> On Behalf Of Alan Bourke > Sent: 01 August 2018 11:31 > To: [email protected] > 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] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMYLkhWxw+tsaG8a-i+m8=mMho7M=VenN+=-ffmqkvii...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
