Article View: borland.public.vdbase.data.sql
Article #1064Re: Searching Substrings in BLOB-Fields...
From: Bowen Moursund
Date: Wed, 20 May 1998 00:00
Date: Wed, 20 May 1998 00:00
16 lines
1155 bytes
1155 bytes
>I got the following problem: I want to store textes longer then 254
>Chars in a Paradox-Database. Because the text contains some special
>chars (like �), I used Blob-Fields instead of Memo-Fields. How can I
>execute a query on these Blob fields to find substrings ?
I don't think you can do it with a query. However, you can do it with a
canGetRow event handler:
queryObj.rowsetObj.canGetRow = {||"substring"$MEMOFIELD}
__
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:
<6juutb$q0814@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<35629487.4923@radiok2r.de>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: ff5a1,311ffe2432b9f697 X-Google-Attributes: gidff5a1,public From: "Bowen Moursund" <teamb@opto-pps.com> Subject: Re: Searching Substrings in BLOB-Fields... Date: 1998/05/20 Message-ID: <6juutb$q0814@forums.borland.com> X-Deja-AN: 354992705 Content-Transfer-Encoding: 8bit References: <35629487.4923@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