Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2004-08-21
3
Medium Priority
?
211 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
The SignAloud Glove is capable of translating American Sign Language signs into text and audio.
Simple Linear Regression
Starting up a Project

879 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