An Oracle Auto Generated Id Issue

Hi

I am currently developing an application with an Oracle backend after years of using Access and SQL Server.

With Access and SQL Server there was an auto-increment option that can be specified for primary keys however unless I have missed somthing in Oracle one has to use the Sequence/Trigger method

My problem occurs when I am adding a new record to a table with an auto-incremented primary key within the application. Within VB, I use a third party component to manipulate data within the database and when
I try to save the new record, the component gives an error indicating that the primary key field cannot be left empty.

When I use SQL + and an Insert SQL statement for the same table the new
record is added with no complaints about the primary key field. How can I
get around this problem? Is there a property/setting within Oracle for the control to know that the primary key is being auto generated/incremented
by use of the sequence/trigger?

thanks in advance
ryan Received on Mon Apr 14 2003 - 12:19:28 CDT