Subject Re: Tutorial?
Author Roman Rokytskyy
> Thanks again, Roman. I am reading up on JDBC now to get more
> familiar with the concepts. But bascially, JBird allows "Firehose"
> (Unidirectional) type recordsets, correct?

Correct. When server implements bi-directional cursors, we will
support it too.

> So that would mean no
> functionality similar to Locate() either?

If you mean method where one can provide some filter condition similar
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 problem
> since I could just execute a WHERE for the exact record I want, but
> would require another trip to DB.

That's how you do this in JDBC. Anyway, getting complete table from
server to client and filtering data locally seems to be less efficient
than executing two queries.

Roman