Article View: borland.public.vdbase.data.sql
Article #1007Re: finding caseless in memos
From: Bowen Moursund (TeamB)
Date: Thu, 28 May 1998 00:00
Date: Thu, 28 May 1998 00:00
18 lines
1532 bytes
1532 bytes
>The problem is: The main-table is local on a CD or remote on a server. >Filtering the table means accessing the CD or the network everytime (and >this could be many times, because I want to draw the result in a grid >with BCB). This is very slow. So I want to use a query, execute it ONE >time and store the result on the local hard-disc. You can use an updateSet object to save a local copy. If the process simply isn't efficient enough to satisfy your network administrator <g>, then you'll have to abandon the use of native tables, and use a C/S DBMS instead. You can use the SQLEXEC() function to pass a query directly to the DBMS, utilizing whatever features it provides. __ Bowen Moursund (TeamB) bowenNOSPAM@nerds.com http://lonestar.texas.net/~moursund/ Try this help resource: http://www.dejanews.com/home_ps.shtml
Technical Details
Message-ID:
<6kk3bn$cct13@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<356B2BCB.4F91@radiok2r.de> <6khj4d$af03@forums.borland.com> <356C53EB.3EA5@radiok2r.de> <6khtuc$akt8@forums.borland.com> <356D1EF6.41C6@radiok2r.de>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,5c89bcf4147e11d0 X-Google-Attributes: gidff5a1,public From: "Bowen Moursund (TeamB)" <teamb@opto-pps.com> Subject: Re: finding caseless in memos Date: 1998/05/28 Message-ID: <6kk3bn$cct13@forums.borland.com> X-Deja-AN: 357341722 Content-Transfer-Encoding: 7bit References: <356B2BCB.4F91@radiok2r.de> <6khj4d$af03@forums.borland.com> <356C53EB.3EA5@radiok2r.de> <6khtuc$akt8@forums.borland.com> <356D1EF6.41C6@radiok2r.de> Content-Type: text/plain; charset="iso-8859-1" X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 Organization: DataTech Mime-Version: 1.0 Newsgroups: borland.public.vdbase.data.sql