Board index » VB & Database

All times are UTC



 SQL Server 6.5 & VB6 ADO 
Author Message
Craig Robertso
#1 / 2
 SQL Server 6.5 & VB6 ADO

Just started using VB6 and SQL 6.5.  I need to move a row from one table to
another table in the same database.

Any suggestions?

Found a SQL Statement that works:  Insert Queries; however I can't seem to
be able to make it work in VB.

Craig Robertson



Sun, 22 Apr 2001 03:00:00 GMT  
Gage
#2 / 2
 SQL Server 6.5 & VB6 ADO
sSQL= **your SQL String**

    oConn.BeginTrans
    oConn.Execute sSQL
    oConn.CommitTrans

        where oConn is your Connection Object



Tue, 24 Apr 2001 03:00:00 GMT  
 
 Page 1 of 1
  [ 2 post ] 

 Relevant Pages 

1. VB6: Data Environment & SQL Server 6.5

2. Syntax for VB6.0 to access SQL Server 6.5

3. VB 6.0 & SQl server 6.5

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

5. sql server 6.5 ado error

6. ADO OLEDB SQL Server 6.5

7. Urgent : VB6 ADO Connecting to SQL 6.5

8. VB & SQL Server 6.5 Contract

9. Visual Basic & SQL server 6.5

10. Syntax for VB6.0 to access SQL Server 6.5

11. Strange Behavior - ADO and SQL Server 6.5

12. ado vb6 sql 6.5 trusted connect failure

  

 
Powered by phpBB® Forum Software