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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VB & Oracle (OO4O) / dynaset.addnew

Status
Not open for further replies.
tigreeuropeo

tigreeuropeo

IS-IT--Management
Oct 2, 2001
30
0
0
ES
I am writing a program in VB and Oracle using OO4O.
My program tries to add records in a database.
I made a couple of programs using the syntax mydyn.executesql(sentSQL) and it works ok, but now I'm trying to use the methods of the dynaset.

OraSession.BeginTrans

mydyn.addnew
mydyn.fields("product") = txtProduct.text
mydyn.fields("price") = txtPrice.txt
...
.......(Does it need mydyn.update?)
...
OraSession.CommitTrans

The question is if the update is necessary or not?
Excuse me if I'm not an expert at VB....
Thanks in advance
 
Status
Not open for further replies.

Similar threads

Ken01
  • Locked
  • Question
VB picturebox graphics 1
Replies
1
Views
57
Andrzejek
Andrzejek
Ken01
  • Locked
  • Question
VB 6 Trig functions 1
Replies
3
Views
91
Andrzejek
Andrzejek
Niki_S
  • Locked
  • Question
How to use 2D array in vb 6? 1
Replies
10
Views
123
Andrzejek
Andrzejek
Niki_S
  • Locked
  • Question
How to read an excel file using VB 6?
Replies
17
Views
184
strongm
strongm
44MARCO
  • Locked
  • Question
MACRO SETTINGS - VBA PROJECT OBJECT MODEL 1
Replies
2
Views
104
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top