🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.vdbase.data.sql
Article #1006

Re: finding caseless in memos

#1006
From: Martin T. Thoma
Date: Thu, 28 May 1998 00:00
36 lines
1899 bytes
Bowen Moursund (TeamB) wrote:
> 
> >so I can't use events or filtering.
> 
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. 

With all the problem descibed in the other messages, I had the idea of
fetching the hole table, searching every record for myself and building
a new (local) table with the result. Bis this is very bad when using the
remote-table (I want to do the SQL-stuff server-sided of course), I
think, my network administrator would be very angry about that...

Greetings

Martin


> I don't see why not. Perhaps you can elaborate?
> 
> >The problem is, too, that there are
> >String like "BaG" (a German shorcut), so I can't do the like-operatione
> >for "Word", "word" and "WORD".
> 
> The canGetRow event handler can be coded as necessary. Again, I don't see
> where the problem is.
> __
> 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: <356D1EF6.41C6@radiok2r.de>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <356B2BCB.4F91@radiok2r.de> <6khj4d$af03@forums.borland.com> <356C53EB.3EA5@radiok2r.de> <6khtuc$akt8@forums.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,5c89bcf4147e11d0
X-Google-Attributes: gidff5a1,public
From: "Martin T. Thoma" <martin@radiok2r.de>
Subject: Re: finding caseless in memos
Date: 1998/05/28
Message-ID: <356D1EF6.41C6@radiok2r.de>
X-Deja-AN: 357239740
Content-Transfer-Encoding: 7bit
References: <356B2BCB.4F91@radiok2r.de> <6khj4d$af03@forums.borland.com> <356C53EB.3EA5@radiok2r.de> <6khtuc$akt8@forums.borland.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql