[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

how can i use sequnce object of orcale from visual basic.net

Posted on 2004-08-21
3
Medium Priority
?
214 Views
Last Modified: 2010-04-17
the sequnce object is created in orcale .. but how can i call dat object from vb.net
0
Comment
Question by:cee1891
1 Comment
 
LVL 21

Accepted Solution

by:
MogalManic earned 500 total points
ID: 11860092
Just reference it in your select statement:
for example:
  insert into MyTable (table_id, field1, field2) values (mySequence.nextVal, 'value1', 'value2')
will insert the next sequence into the table 'MyTable'.  There is also mySequence.curVal, to retrieve the current value, but I have not found many uses for it because it only is valid after a call of nextVal in the same transaction.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
Six Sigma Control Plans

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question