🚀 go-pugleaf

On Fri, 22 May 1998 19:36:59 +0200, "Martin T. Thoma" <martin@radiok2r.de>
wrote:


>no it a Control from BCBuilder 3.0. But I thought it was a SQP Problem,
>because when I did the query, there was an error in the SQL-statement
>(because you can't search BLOBs with SQL).

A bit of clarification on that.

The ability to filter in an SQL statement based on the contents of a memo
column is implementation-specific. Some database systems will allow it,
others not, and still others partially with limitations.

Local SQL, what the BDE uses for dBASE and Paradox tables, falls into the
latter category. You can use the LIKE predicate in a WHERE clause to filter
based on the contents of a memo column.

  SELECT *
  FROM "Archive.dbf" A
  WHERE (A."Notes" LIKE "%C++Builder%")

However, in the 32-bit version of the BDE, you cannot also apply the SQL
function UPPER to the memo column. This precludes making the LIKE predicate
comparison case-insensitive, as you can with CHAR columns.

For other database systems that can be accessed directly by the BDE,
through ODBC, or the SQL Links, the documentation for the specific database
system used should be consulted to see whether and to what degree using a
memo column in this manner is supported.

**************************************************************************
Steve Koterski
INPRISE Corporation, Technical Publications
http://www.inprise.com/delphi