Subject | Re: Tutorial? |
---|---|
Author | Roman Rokytskyy |
Post date | 2003-11-29T20:41:58Z |
> Thanks again, Roman. I am reading up on JDBC now to get moreCorrect. When server implements bi-directional cursors, we will
> familiar with the concepts. But bascially, JBird allows "Firehose"
> (Unidirectional) type recordsets, correct?
support it too.
> So that would mean noIf you mean method where one can provide some filter condition similar
> functionality similar to Locate() either?
to where clause (at least I remembed from my Delphi times such method
existed in TTable class), no, there is no such method in JDBC
specification. Specification allows you only positioning (JayBird
allows only next, but specs define bunch of methods), not filtering.
But as far as I know, Borland created own classes (dataExpress, I
think) that have such methods. These components should have similar
functionality to Delphi ones.
> Its not that big a problemThat's how you do this in JDBC. Anyway, getting complete table from
> since I could just execute a WHERE for the exact record I want, but
> would require another trip to DB.
server to client and filtering data locally seems to be less efficient
than executing two queries.
Roman