I have this question:
if in a Java program I have a fragment of code like the following:
--------------
String sql = "SELECT People.firstName, People.lastName FROM People order by lastName";
PreparedStatement pst = conn.prepareStatement(sql);
ResultSet rs = pst.executeQuery();
how can I search a value int it without scanning all records in the resultSet with a “while(rs.next())”? I would search, for example, the lastName “Berry”.
In ADODB you had something like
rs.Filter="People.lastName='Berry'"
but this was simply "merged" with the previous query, and in your case this generates
SELECT People.firstName, People.lastName FROM People WHERE People.lastName='Berry' ORDER BY lastName
so just execute another query again.
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
