[AccessD] Getting the Primary Key of a New records in Oracle

Just a guess since it's been a long time since I did any Oracle work
--
can you use a pass through query to Oracle looking for your PK field where
rownumber = (select max(rownumber) from yourtableName) ??


On Tue, Nov 5, 2013 at 4:13 PM, Heenan, Lambert <Lambert.Heenan at aig.com>wrote:

> Does anyone know how I can retrieve the primary key value from a new
> record just added to a linked Oracle table using VBA?
>
> I.e. I create a records using VBA, populate the fields with VBA and update
> the record. How do I then find out what the primary key value allocated by
> Oracle is? The key field is of type NUMBER(10) and it is populated by a
> trigger (which I have no control over).
>
> Lambert
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>