| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO 2.7 recordset problem
I have the following bit of code
There are 13 records in the table i'm reading into the recordset from. I keep getting an OVERFLOW error that has to do with the rs.Fields(1) line below... If i remove that line.. loop works fine of course The array has 14 cells so there's no problem there. i = 1 While Not rs.EOF BucketArray(i) = rs.Fields(1) i = i + 1 rs.MoveNext Wend Any ideas? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ADO 2.7 recordset problem
On Dec 15, 12:15 pm, maz wrote:
I have the following bit of code There are 13 records in the table i'm reading into the recordset from. I keep getting an OVERFLOW error that has to do with the rs.Fields(1) line below... If i remove that line.. loop works fine of course The array has 14 cells so there's no problem there. i = 1 While Not rs.EOF BucketArray(i) = rs.Fields(1) i = i + 1 rs.MoveNext Wend Any ideas? SORRY ... I got it ... It was just an array data type issue Disregard this thread... thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem with recordset find | Excel Programming | |||
| ADO recordset problem with stored procedure | Excel Programming | |||
| ADO Recordset Problem -- Left Join | Excel Programming | |||
| ADODB Recordset problem | Excel Programming | |||
| Conceptual Problem with DAO/ADO Recordset | Excel Programming | |||
Linear Mode
