Re: Fujitsu ADO Data access guidance needed


Robin Lee wrote:

I realize that RDB's do not store (nor access) data in the sequential
manner which we may be accustomed to in traditional ISAM databases.
Most of what I need to do is to extract records of a certain value or
within a certain range. In ISAM that would be START KEY NOT LESS THAN
and PERFORM UNTIL (greater than), and in SQL SELECT - FROM - WHERE - IN
... something along those lines. From there I will likely build an ISAM
workfile, so sequence of the RDB data is not important. And the volume
of data is not tremendous so ODBC/SQL will likely be adequate.

There is an ORDER BY clause if you need a particular sequencing.

.