aspose file tools*
The moose likes JDBC and the fly likes Regarding JDataStore DataBase Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Regarding JDataStore DataBase" Watch "Regarding JDataStore DataBase" New topic
Author

Regarding JDataStore DataBase

srinath jeyanthi
Greenhorn

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.
query:
update emp set job='manager' where empno in(10,20,30);
this query is not working our JDataStore DataBase.
thanks
regards,
jeyanthi.
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: http://aspose.com/file-tools
 
subject: Regarding JDataStore DataBase