|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
Free Web 2.0 Code Generator! Generate data entry and reporting .NET Web apps in minutes. Quickly create visually stunning, feature-rich apps that are easy to customize and ready to deploy. Download Now!
|
|
#1
August 26th, 2004, 10:38 AM
|
|||
|
|||
|
problem copying fields
I have an Access table with 135 fields, I want to select a record in the table, and copy it to a table in a different database. I then want to review the and edit the data and when happy write the whole record back to the first table.
Having set up a pair of ADODC controls connected to the tables I tried like this Adodc1.recordset = “Select * from table1 where Myfield1 = ’”& target &”’ Adodc2.recordset.addnew For I=0 to Adodc1.recordset.fields.count-1 Adodc2.recordset.fields(I)=Adodc1.recordset.fields (I) Next I Adodc2.recordset.updatebatch This works fine but I don’t want to keep adding records to the second table I want to overwrite the first record each time so I replaced the .addnew with .movefirst Now I get errors on the update line saying “too many fields defined”, if I reduce the number of fields copied I get “the query is too complex” Any idea what is going on here?
|
|
#2
August 26th, 2004, 11:10 AM
|
||||
|
||||
|
Just run an insert command to insert the new record into the other database.
Code:
INSERT INTO Database1.dbo.TableName SELECT * FROM Database2.dbo.TableName WHERE SomeField = SomeValue I would strongly advise against using ADODC controls in VB6. They are very limiting in their abilities, besides it's always better to learn to code everything yourself, you have much more flexiblity.
|
|
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > problem copying fields |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
