compass wrote, On 01.08.2004 06:18: > Now I can do the sql like 'select ....' by > CacheSys\Dev\Java\samples\CJTest7.java > sql = "SELECT ID, Name, DOB, SSN FROM Sample.Person WHERE Name %STARTSWITH > ?"; > cq = new CacheQuery( server, sql );
query = "compass"; // param should be set, right? > rs = cq.execute(query); > but I don't know how to sql like > sql = "delete FROM Sample.Person WHERE Name %STARTSWITH ?"; PreparedStatement pstmt = server.prepareStatement(sql); pstmt.setString(1,"compass"); pstmt.executeUpdate(); HTH Gerd
