Sequence

Sequence

Postby hrmuhr » Fri 28 Apr 2006 14:41

Hi,

How can I use Oracle Sequence with parameters, like that.

Mycmd.Parameters['id'].Value := MySequence.NextVal;
Mycmd.Parameters['name'].Value := Text1.text;

I need some example,

Thanks.
hrmuhr
 
Posts: 2
Joined: Fri 28 Apr 2006 14:33

Postby Paul » Fri 28 Apr 2006 14:57

There are no specific components or features for Oracle Sequence in OraDirect .NET. You have to use MySequence.NextVal directly in SQL statement
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06


Return to dotConnect for Oracle