Error doing update with VB 3.0 and SQL Server 6.5 
Author Message
 Error doing update with VB 3.0 and SQL Server 6.5

We have a VisualBasic 3.0 program that contains the following code:

    myDs is a Dynaset
    myDs.AddNew
    ---some assignments---
    myDs.Update

When run on two Win95 machines (with 32-bit ODBC) it runs fine.
However, when run on a WFW 3.11 machine (with 16-bit ODBC) the line
myDs.Update generates a runtime error:
    "Record is deleted."

If we replace myDs.AddNew with myDs.Edit, everything is ok. Only
myDs.AddNew has an error during Update.

Does anyone have any ideas? Do I have to copy certain files to
the rest of the machines?

Any response will be appeciated. Thanks,
Jason.

--

Department of Computer Science      /     \ Tel (work): +61 9 380 1840
The University of Western Australia *_.-._/ Fax (work): +61 9 380 1089
Nedlands  W. Australia  6907             v  Tel (home): +61 9 386 8630



Mon, 25 Oct 1999 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Error 10095 with SQL Server 6.5 and updates with cursors

2. Error during update of a dynaset with VB 3.0 and SQL Server 6.0

3. S10008 Error From SQL Server 6.5 Running VB 5.0 Stored Procedures

4. S10008 Error From SQL Server 6.5 Running VB 5.0 Stored Procedures

5. S10008 Error From SQL Server 6.5 Running VB 5.0 Stored Procedures

6. VB5: Updating recordset on MS SQL-Server 6.5

7. DAO Update Deadlocks SQL Server 6.5, but not 6.0

8. Update problem with VB6 and SQL Server 6.5

9. Access 2.0/VB 3.0/SQL 6.5 simultaneous read problem

10. Data objects closed error in ADO 2.1 and SQL server 6.5

11. sql server 6.5 ado error

12. Connection errors with Visual Basic 4 16-bit and SQL server 6.5 on a 3.11 platform

 

 
Powered by phpBB® Forum Software