Trying to use Oracle Sequence Value - First Time

S

steph

Hi,

I'm using Microsoft Access 2003 to access some data in an Oralce table.
The one problem I have is to utilize an Oracle sequence from within
Access. I have defined an ODBC pass-through query returning the
sequence value, this works fine.

Now I'm trying to convince Access to use the value returned by the
pass-through query as a primary-key value for new records. I've tried
to achieve this by setting the default value for the primary-key field
to the return value of the pass-through query. This apparently does not
work - when running the form the primary key field just display's
'#Error'. Do I have a datatype-problem here? Or is there a better
method to fill the primary-key field of new records?

I hope this question is not too dumb, but I'm rather new to access ;-)
Thanks,
Stephan
 
S

steph

found out how it works: i'm using now the before-insert event calling
function DLookup()
 
Top