| Recordset updating [message #115043] |
Wed, 06 April 2005 23:13 |
makdt
Messages: 2
Registered: March 2005
|
Junior Member |
|
|
hi i am using vb front end and oracle back . need to know how to update only some columns of the table.
For example adodc1.recordset.update will update all the records i.e. all the columns. I want to update specific columns like so
adodc1.recordset.fields(0).value = txtaddress.text
adodc1.recordset.fields(2).value = txtaddress.text
....
....
...
...
then i want to update only the fields in which i changed the values above( like i havent changed the the ...fields(2).value
I want to do this because if i try to update the entire recordset even the column for id numbers which i have set as primary key in oracle through SQL, i get a unique contraint violation.
please help me around this.
Is there another way to update specific column only?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
