Subject RE: [IBO] quickest way to fill a list with table data
Author Kaputnik
depends largely, what you want to get out of the query. Only one column?
Comma-separated values? custom separated values? XML?
If you want the result-set of a query in xml, then go and try this:
TIB_Dataset.asXML :-)
If you need only one column's values, then the best thing to do would likely
be to use an TIB_Cursor and loop through all rows unidirectionally.
If oyu need several column's values, use TIB_Export

CU,

Nick Josipovic

BIT Institute
Prof. Dr. Franz Steffens
University of Mannheim
T: ++49 621 181 1621
M: ++49 179 133 44 16
S: ++49 621 181 1622
F: ++49 621 181 1618
nick.josipovic@...


> -----Original Message-----
> From: Duilio Foschi [mailto:dedalus@...]
> Sent: Sunday, March 03, 2002 12:09 AM
> To: ibobjects@yahoogroups.com
> Subject: [IBO] quickest way to fill a list with table data
>
>
> I have to fill a TStrings with data easily sampled with a SQL query.
>
> Which is the quickest method to retrieve them ?
>
> TYIA
>
> Duilio Foschi
>
>
>
> __________________________________________________________________
> _________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> __________________________________________________________________
> _________
> http://www.ibobjects.com - your IBO community resource for Tech
> Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>