Solved

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

Posted on 2004-08-21
3
205 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 21

Accepted Solution

by:
MogalManic earned 125 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

A short article about problems I had with the new location API and permissions in Marshmallow
In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.

739 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