I Need To Move a Record
from one Table in a
Database To another Table
I am using ado in vb 6.0 plz help me!

Re: moving recorc from one table to another 80 80

You didn't provide the table structures so I'll assume the tables have the same structure. I have no idea how much detail you need so I'll start with a little and you can ask for more as you need. If you have an ADODB.Connection object named con then you can move the record in two steps. Step 1 will copy the record and step 2 will delete the record from the source table. Because you have provided no details I can give only an example.

con.Execute("INSERT INTO Table2 SELECT * FROM Table1 WHERE SomeField = 'Some Value'")
con.Execute("DELETE FROM Table1 WHERE SomeField = 'Some Value'")
Re: moving recorc from one table to another 80 80

Of course, you should do error checking at each step to ensure that you don't delete the record if it fails to insert into Table2.

Re: moving recorc from one table to another 80 80

What I suggest is, firstly call the records from the First Table that you need to transfer on to a VB Form on to Text boxes or a ListView.Then save those records in the table you require. Then write the Deleting Codes on to the same Button Following the Saving Codes, to be executed from the previous table.

Re: moving recorc from one table to another 80 80

Just go into Access and create a query. Make sure that it works. Then plug the result into VB6. For how to create a query

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.