By chance I just got back from a meeting where one of the guys was an SQL programmer and had worked a lot with Access and I mentioned this question. He confirmed that global searching in SQL is not trivial but said that if the table structure of the DB were known one could do it by writing a program, in Visual Basic for example, which accepts the search term and generates SQL search parameters. We didn't get into how to format the output. Paddy
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Kowallek Sent: 20 June 2003 21:35 To: [EMAIL PROTECTED] Subject: Re: [LegacyUG] Search Woes and Pleas On Fri, 20 Jun 2003 20:05:19 +0100, "Chris Knight" <[EMAIL PROTECTED]> wrote: >BTW I saw the apparently knowledgable comments earlier about searching >SQL databases but I really can't buy the bottom line. I don't think anyone said it couldn't be done. It's probably a question of performance, especially in large databases. >I was quite serious in >saying that virtually all the major software I use can search for any >word in the databases used by the software and at least some of these >certainly use SQL, at least as a query language. Not being flip, but please name a few that use SQL to allow a global search across all columns in all tables. I ask because I can't think of any. I'm not saying there aren't any, I just can't think of any. -- Dennis M. Kowallek [EMAIL PROTECTED] ****************** Legacy User Group Etiquette guidelines can be found at: http://www.LegacyFamilyTree.com/Etiquette.asp To find past messages, please go to our searchable archives at: http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/ To unsubscribe please visit: http://www.legacyfamilytree.com/LegacyLists.asp Legacy User Group Etiquette guidelines can be found at: http://www.LegacyFamilyTree.com/Etiquette.asp To find past messages, please go to our searchable archives at: http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/ To unsubscribe please visit: http://www.legacyfamilytree.com/LegacyLists.asp
