Insert oracle sequence generated value using vb.net -
i'm new vb.net. need modify existing application connects oracle db.
my question is: how can insert value generated oracle sequence vb? have following code far:
dim mpdata new maximodatasettableadapters.measurepointtableadapter dim mptable new maximodataset.measurepointdatatable mpdata.fill(mptable) dim mdata new maximodatasettableadapters.measurementtableadapter dim mtable new maximodataset.measurementdatatable dim mprow maximodataset.measurepointrow each mprow in mptable dim mrow maximodataset.measurementrow mrow = mtable.newrow() mrow.pointnum = mprow.pointnum mrow.measuredate = cstr(now) mrow.measurementvalue = ttotal mtable.rows.add(mrow) mdata.update(mtable) next but receive error because have field, rowstamp, generated sequence?
please advice.
regards, radu.
in oracle columns not "generated sequence". need fetch next value sequence yourself, , supply value when insert row:
select mysequence.nextval some_variable dual;
then use value some_variable in insert statement.
Comments
Post a Comment