Guest_imported
New member
- Jan 1, 1970
- 0
I am trying to update a form that has fields from two seperate tables in my Oracle database. I am unable to do so. Is there any tricks to having two tables on one form? thanks in advance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ADO recordset
- Thread starter Guest_imported
- Start date
- Status
ya..
u can either create two adodc controls and then update them
or u can do it at runtime..
simply at clicking the command button
add this code:
adodc1.recordset.addnew
adodc2.recordset.addnew
adodc1.recordset.fields(<fieldname>)=<textbox name>
adodc2.recordset.fields(<fieldname>)=<textbox name>
adodc1.recordset.update
adodc2.recordset.update
if this cant help then contact me on varnitpoddar@indiatimes.com
Good Luck
Varnit
u can either create two adodc controls and then update them
or u can do it at runtime..
simply at clicking the command button
add this code:
adodc1.recordset.addnew
adodc2.recordset.addnew
adodc1.recordset.fields(<fieldname>)=<textbox name>
adodc2.recordset.fields(<fieldname>)=<textbox name>
adodc1.recordset.update
adodc2.recordset.update
if this cant help then contact me on varnitpoddar@indiatimes.com
Good Luck
Varnit
- Status