Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.databases > #283

Re: Dbase and no 'Like' s

Show all headers | View raw

  To: comp.lang.java.databases
Kees wrote:

> My program  connects to  an old dbase 4 database. The connectionstring
> is:
> 
> jdbc:odbc:Driver={Microsoft dBASE Driver
> (*.dbf)};mode=read;DriverID=277;DBQ="<dbfdir>"
> 
> I can read the contents of the tables with i.e.
> select * from nawaanv where functie='k' (80 records)
> 
> But when I use: select * from nawaanv where functie like '%k%', I get
> zero records. I've changed % to *, single quotes to double quotes,
> nothing helps, always zero records (and sometimes error 15877). 
> 
> In a Delphi program, using the ADO component and  odbc for DBASE, I
> get good results with ....like '%k%' (120 records).
> 
> What am I doing wrong? Do I have to switch to ADO in Java (not much
> info).... I'am quit new to Java.
> 
Sounds like a driver problem. There's many JDBC-dbase drivers out there,
but it seems most are commercial.

Can you set the dBase version in this driver? That might help tell it
the features to support.

---
 * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet!
--- Synchronet 3.15a-Win32 NewsLink 1.92
Time Warp of the Future BBS - telnet://time.synchro.net:24

Back to comp.lang.java.databases | Previous | Next | Find similar

Thread

Re: Dbase and no 'Like' s "Sabine Dinis Blochberger" <sabine.dinis.blochberger@THRWHITE.remove-dii-this> - 2011-04-27 15:22 +0000

csiph-web