SQL Like predicate with MS Access 95 Tables

Jason Corley

Delphi Developer

Sun, 31 Jan 1999 03:00:00 GMT

SQL Like predicate with MS Access 95 Tables

I'm using D2 via ODBC 3.0 drivers to an MS Access 95 Table, and I'm
trying to get a selection of records with a TQuery. The TQuery looks
like:
TQuery.SQL = 'SELECT Name FROM Table WHERE Name LIKE 'Foo%';'

The ODBC driver complains about the LIKE predicate. Is it supported?
Does anyone know how to use LIKE predicates with ODBC/MSAccess tables?

Jason

Peter Arrenbrech

Delphi Developer

Wed, 03 Feb 1999 03:00:00 GMT

Re:SQL Like predicate with MS Access 95 Tables

You might want to try using Opus DirectAccess, the fast BDE replacement for
Jet database access in Delphi 2.0. For information and a trial version,
check out

http://www.opus.ch/ODA

Regards,
peo <p...@opus.ch>

Jason Corley <corl...@smptgw2.musc.edu> wrote in article
<32128DB1.1...@smptgw2.musc.edu>...

Quote

> I'm using D2 via ODBC 3.0 drivers to an MS Access 95 Table, and I'm
> trying to get a selection of records with a TQuery. The TQuery looks
> like:
> TQuery.SQL = 'SELECT Name FROM Table WHERE Name LIKE 'Foo%';'

> The ODBC driver complains about the LIKE predicate. Is it supported?
> Does anyone know how to use LIKE predicates with ODBC/MSAccess tables?

> Jason

Other Threads

1. Retrieving MS Access 95 Table Information

2. MS Access 95 Table - DBGrid, Multiselect

3. CONVERTING ACCESS TABLES TO MS SQL TABLES

4. Delphi components for MS Access 95/97/2000

5. Connecting MS Access 95/97 to a IntrBase server..(local)

6. ms access 95 old delphi program and upgrade to office 2000

7. Delphi components for MS Access 95/97/2000

8. Delphi, Banyan, Windows 95, and MS SQL Server 6.0

9. access to MS ACCESS / MS SQL without BDE?

10. Opening Access 95 Table Without Login Prompt (D3)