Home » Infrastructure » Windows » Recordset updating
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?
Previous Topic: Dos/win batch file
Next Topic: I cannot install oracle 9i
Goto Forum:
  


Current Time: Mon Aug 15 07:31:05 CDT 2022