muraliambt
Programmer
Dear All,
Im using VB 6.0 and ORCALE 9i Lite Data base. I am getting the above mentioned error while try to Move backupward or Last record.
I have created the DSN=VBSIP (Oraclite ODBC Driver) which refers to my oracle lite database.
Here is the code.
Set sDBconn = New ADODB.Connection
sConnstring = "DSN=VBSIP;UID=USER;PWD=PWD"
sDBconn.Open sConnstring
This how i open my recordset.
RS.Open "select br_code, vou_curr_code, cv_serial_no, cv_date, max(amend_no) as amend_no from fom_cash_vou group by br_code, vou_curr_code, cv_serial_no, cv_date Order by br_code, vou_curr_code, cv_serial_no ", sDBconn, adOpenDynamic, adLockBatchOptimistic
I am able to move forward and move first record.
Thanks...
Muraliamabt.
Im using VB 6.0 and ORCALE 9i Lite Data base. I am getting the above mentioned error while try to Move backupward or Last record.
I have created the DSN=VBSIP (Oraclite ODBC Driver) which refers to my oracle lite database.
Here is the code.
Set sDBconn = New ADODB.Connection
sConnstring = "DSN=VBSIP;UID=USER;PWD=PWD"
sDBconn.Open sConnstring
This how i open my recordset.
RS.Open "select br_code, vou_curr_code, cv_serial_no, cv_date, max(amend_no) as amend_no from fom_cash_vou group by br_code, vou_curr_code, cv_serial_no, cv_date Order by br_code, vou_curr_code, cv_serial_no ", sDBconn, adOpenDynamic, adLockBatchOptimistic
I am able to move forward and move first record.
Thanks...
Muraliamabt.