Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Regarding JDataStore DataBase

 
srinath jeyanthi
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13974
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
IN merely is a short form of or =
Try this:

update emp set job='manager' where
empno = 10 or
empno = 20 or
empno = 30
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic