Thread: query problem
View Single Post
  #1 (permalink)  
Old September 8th, 2003, 01:26 AM
mateenmohd mateenmohd is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: abu dbabi, , United Arab Emirates.
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts
Default query problem

Query No1 give following error
Query 1
---------
rs.Open "SELECT contractno,recordno,category,contractor FROM arc where contractno='"&contractno&"'",cn,1,2
rs.PageSize=100

Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/dcil2/paging7.asp, line 27


When I change query ie.

Query 2
---------
rs.Open "SELECT contractno,recordno,category,contractor FROM arc where contractno='10 ’",cn,1,2
rs.PageSize=100

it give no error, whey ? how can use query no 1, I want to use query no.1 becasuse contractno value is dynamic (not constant)
and contractno received the value from the previous page.
Reply With Quote