RDO-->SQL 6.5. GetChunk S1109 error 
Author Message
 RDO-->SQL 6.5. GetChunk S1109 error

Can anyone shed any light on why I cannot seem to get the GetChunk
method to work with my RDO-->SQL 6.5 connection.
The line of code I have (as per the example in Hitchhiker's Guide to VB
and SQL) is
dim original as string
original = rcStoresReq!ReqDetails.GetChunk(50)
(where rcStoresReq is the Resultset and ReqDetails is the column name)
returns the error "S1109, Invalid cursor position"
What am I doing wrong?
Thanks
Julia



Mon, 28 Feb 2000 03:00:00 GMT  
 RDO-->SQL 6.5. GetChunk S1109 error

Do you know how else I can retrieve and save 'memo' fields to the
database?

Quote:

> You need to use server side cursors for the chunk method to function
> properly



> > Can anyone shed any light on why I cannot seem to get the GetChunk
> > method to work with my RDO-->SQL 6.5 connection.
> > The line of code I have (as per the example in Hitchhiker's Guide to
> VB
> > and SQL) is
> > dim original as string
> > original = rcStoresReq!ReqDetails.GetChunk(50)
> > (where rcStoresReq is the Resultset and ReqDetails is the column
> name)
> > returns the error "S1109, Invalid cursor position"
> > What am I doing wrong?



Mon, 28 Feb 2000 03:00:00 GMT  
 RDO-->SQL 6.5. GetChunk S1109 error

You need to use server side cursors for the chunk method to function
properly



Quote:
> Can anyone shed any light on why I cannot seem to get the GetChunk
> method to work with my RDO-->SQL 6.5 connection.
> The line of code I have (as per the example in Hitchhiker's Guide to VB
> and SQL) is
> dim original as string
> original = rcStoresReq!ReqDetails.GetChunk(50)
> (where rcStoresReq is the Resultset and ReqDetails is the column name)
> returns the error "S1109, Invalid cursor position"
> What am I doing wrong?



Mon, 28 Feb 2000 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. RDO error when upgrading from SQL 6.5 to SQL 7.0

2. File DSN's and SQL Server 6.5 and RDO

3. VB4, SQL Server 6.5, RDO and ODBC

4. RDO, BLOB & SQL 6.5

5. RDO Option Value Changed and SQL 6.5

6. VB4 RDO Performance: SQL Server 6.0 vs 6.5

7. Visual Basic RDO and SQL Server 6.5 null Problem

8. RDO and SQL Server 6.5

9. RDO and SQL Server 6.5

10. RDO, Visual C++ 4.2 instead of VB40, MS SQL 6.5

11. pdssql.dll missing & SQL 6.5 / RDO problems

 

 
Powered by phpBB® Forum Software