File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Regarding JDataStore DataBase Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Regarding JDataStore DataBase" Watch "Regarding JDataStore DataBase" New topic

Regarding JDataStore DataBase

srinath jeyanthi

Joined: Feb 14, 2001
Posts: 18
please help me any body my question is,
i am using my java project JDataStore as backend .it is platform
independent.In this database does not support IN operator while i am updating four different records that i given IN operator where clause.And also won't support substr function also.plese give the alternate solution for this situation.
update emp set job='manager' where empno in(10,20,30);
this query is not working our JDataStore DataBase.
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
IN merely is a short form of or =
Try this:

update emp set job='manager' where
empno = 10 or
empno = 20 or
empno = 30

Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
I agree. Here's the link:
subject: Regarding JDataStore DataBase
It's not a secret anymore!