Solved

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

Posted on 2004-08-21
3
203 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
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

ScreenConnect 6.0 Free Trial

Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
mapBully challenge 6 134
advertisement module in core php 4 162
recursion example 16 126
Filename to be appended with DateTimeof Download 3 55
Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

772 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