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

Popular posts from this blog

Add email recipient to all new Trac tickets -

400 Bad Request on Apache/PHP AddHandler wrapper -

php - Change action and image src url's with jQuery -