On Sun, 17 Jan 2010 07:36:17 +0900, Jim Walton <[email protected]> wrote:
>Since you wrote the program, you should know. My impression is that >SQL doesn't handle substrings as well as VB The problem is that this additional functionality (substrings, etc.) is not built in to the Jet database engine, which LTools and Legacy talk to. You can do it in MS Access because the functionality is actually in the client. Think of MS Access as a client and Jet as a server. Real databases like MySQL build this functionality into the server. I think this is why a search and replace in Legacy takes so long for large tables (like Citations). Legacy must do a lot of this processing on the client side a row at a time. -- Dennis Kowallek (LTools) http://zippersoftware.com/ltools http://groups.yahoo.com/group/ltools Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
