Re: reading random records with JDBC?

On Nov 27, 5:08 pm, "йенс мартин шлаттер" <MfwEwkCtz..._at_spammotel.com> wrote:
> > The sample clause was mentioned before - how about
> > reading from table A, using SAMPLE, and searching
> > for corresponding entries from b (preferably using
> > the primary key on B)?
>
> This is a very good idea, thank you!
> But it means that the program has to find out what the primary key is
> and which type it is. But it could work.
>
> JMS
Aha! He can be taught!

With the Primary Key, you searches will be MUCH faster. This is the direction I clumsily tried to lead you toward.

You do not care what the type of the PK columns are. For there to be corresponding rows the types must just match between the tables. For you to compare rows, you must alredy know the columns are of the same type.

Much better.
  Ed Received on Tue Nov 27 2007 - 23:00:27 CST