Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

QueryDataset

7 views
Skip to first unread message

Jakem Schott

unread,
Apr 20, 2007, 11:52:50 PM4/20/07
to

Hello

How can I programmatically loop through the results of my query. I want to assign each field to a variable, can someone point me in the direction of some example code on how to do this???

Thanks

Jake

Paul Nichols [TeamB]

unread,
Aug 17, 2007, 11:42:50 AM8/17/07
to
Do you need to use the QueryDataSet or can you use standard JDBC ResultSet?

The best way to do something like this, is to use Reflection. Using
something like ResultSetMetaData can provide what you need.

Curious however, why you want to assign the results to a variable. You
would be much better off using RowSets for cached results from a query.
Much less work, similar results.


0 new messages