Visual Basic Code , VB.NET Code, VB Code
  Home   :  Code   :  Forums   :  Submit   :  Mailing List   :  About   :  Contact
A1VBCode Forums
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      

Home » Visual Basic (VB 4/5/6) » Database Programming » Transfer Data from One Table to another


Transfer Data from One Table to anotherExpand / Collapse
Author
Message
Posted 8/3/2008 8:19:52 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 8/3/2008 8:05:05 PM
Posts: 2, Visits: 2
Please Master's,

I am working on a project. After making use of the Data in Publish(Table) I want it to transfer to Publish_Archive (Table) for history purpose, on a single command button click. The two table located on single Database in VB6.


Please I need you answer.

Thanks


NeverDeLess
Post #25500
Posted 8/26/2008 2:29:00 AM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 10/10/2008 5:47:58 AM
Posts: 27, Visits: 206
a simple database manipulation... just retrieve the data of 1st table save it to the second table then after that back to the first table delete the record you tansfered in the second table if you using ms access db but if use mysql or ms sql server db you can use simple query to process that...
Post #25618
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 1 (1 guest, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Brian, Peter

PermissionsExpand / Collapse

All times are GMT -5:00, Time now is 5:11am