Difference between TdaSQL properties?

rbuser

In TdaSQL there are the following properties:

AvailableSelectTableCount: Integer
AvailableSelectTables[aIndex: Integer]: TdaTable

AvailableTableCount: Integer
AvailableTables[aIndex: Integer]: TdaTable

What's the difference between the two pairs and why?
(They are not mentioned in the Help file.)

nicocizik

Hi Peter,

The FAvailableTables field keeps track of all the tables available to the
user from the database connection. The FAvailableSelectTables keeps track
of the available tables left to select (for instance if the user has already
selected two tables for their dataset, those tables are no longer available
to select).

The TdaSQL class is primarily an internal class and we do not recommend
using it directly. What are you trying to accomplish?

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

nardmoseley

Use TdaSQLBuilder to manipulate the TdaSQL associated with a
QueryDataView/DataPipeline

TdaSQLBuilder is documented in the RBuilder.hlp. Access the help topic for
TdaSQLBuilder and then naviate to the related subtopics which include sample
code.

--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Solved the problem. It was due to an SQL condition that excluded database
information from TdaSQL.

I see.

Is there a good reason for such a limitation?

I didn't see the point using TdaSQLBuilder. I know it's a shell with a
simpler interface, but simplicity is not what I require.

Joins. I need to replace parts of the standard interface in the query
builder. I'll continue on another thread, as this particular problem has
been solved.