Re: ADO -> Oracle

From: CoachCS <coachcs_at_aol.com>
Date: 30 Oct 1999 15:42:43 GMT
Message-ID: <19991030114243.11811.00000341@ng-cn1.aol.com>

Kenneth, are you using parameters in your select statement? If so you get a read-only recordset and your 'Move's are limited.

declare a variant and pull the recordset into it by:

vData = recordset.GetRows

The variant will be poulated with all tyhe rows. It will be a two dimensional variant array. The first dimension is for columns (fields) the second for row.

If you select statement is "select a, b, c from t where a = 'x';" and it returns a few rows, then vData(0,0) will contain a of the first row, vData(1,0) will gave b of the first row. vData (2,3) will contain c of the 4th row. 2 is third (0,1,2) and 3 is 4th( 0,1,2,3)(

The number of rows is -- Ubound(vData, 2) + 1

Dov Trietsch

BTW, this is all fully explained in my new book From WROX. It is now going to print and will be on the shelves 12/1/1999

www.WROX.Com go to database then future books Received on Sat Oct 30 1999 - 10:42:43 CDT