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

Re: Dbase and no 'Like' s

Path	csiph.com!x330-a1.tempe.blueboxinc.net!feeder1.hal-mli.net!news.glorb.com!news-out.readnews.com!news-xxxfer.readnews.com!news-out.news.tds.net!newsreading01.news.tds.net!86597e80!not-for-mail
From	"Sabine Dinis Blochberger" <sabine.dinis.blochberger@THRWHITE.remove-dii-this>
Subject	Re: Dbase and no 'Like' s
Message-ID	<UZCdneUmo9AvUXTVnZ2dnUVZ8szinZ2d@novis.pt> (permalink)
X-Comment-To	comp.lang.java.databases
Newsgroups	comp.lang.java.databases
In-Reply-To	<025fe4tcl6fa91af1k4s86f5qgctpl32c7@4ax.com>
References	<025fe4tcl6fa91af1k4s86f5qgctpl32c7@4ax.com>
Content-Type	text/plain; charset=IBM437
Content-Transfer-Encoding	8bit
X-Gateway	time.synchro.net [Synchronet 3.15a-Win32 NewsLink 1.92]
Lines	32
Date	Wed, 27 Apr 2011 15:22:50 GMT
NNTP-Posting-Host	96.60.20.240
X-Complaints-To	news@tds.net
X-Trace	newsreading01.news.tds.net 1303917770 96.60.20.240 (Wed, 27 Apr 2011 10:22:50 CDT)
NNTP-Posting-Date	Wed, 27 Apr 2011 10:22:50 CDT
Organization	TDS.net
Xref	x330-a1.tempe.blueboxinc.net comp.lang.java.databases:283

Show key headers only | 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