Board index » vbscript

All times are UTC



 Checking for next object in record 
Author Message
Steve Pohlma
#1 / 2
 Checking for next object in record

I am trying to compare one record with another record with out moving
the pointer on the current cursor.

ex.   if (rs("Item") = rs("Item")+1) then

Thanks in advance

Steve



Sun, 06 Jan 2002 03:00:00 GMT  
Dan Pfeffe
#2 / 2
 Checking for next object in record
Hi Steve,
You could save the current recordset field value, do a movenext and then do
the comparison.
HTH,
Dan


Quote:
> I am trying to compare one record with another record with out moving
> the pointer on the current cursor.

> ex.   if (rs("Item") = rs("Item")+1) then

> Thanks in advance

> Steve



Sun, 06 Jan 2002 03:00:00 GMT  
 
 Page 1 of 1
  [ 2 post ] 

 Relevant Pages 

1. Next Record Value Check

2. Doing Error Checking before moving to next record

3. Checking if the next record is the last

4. Enter,Next Row and Clear for Next record

5. going to next record after inserting a new record

6. Next / Previous Record with JScript using ADO

7. Checking for matching records in two tables with different record structures

8. Checking in Err Collection using On Error Resume Next

9. logon script to check the next available drive letter (The code is a bit long)

10. How to: Loop through all objects and count the checked check boxes

11. For Each....Next...Do Loop?/Current record

12. How to move to the next record?

  

 
Powered by phpBB® Forum Software