angus comber

Hello

I am using ATL OLE DB classes to wrap OLE DB. When I for example do a:
INSERT INTO MyTable (Company, Address1) VALUES ('XYZ', '1 The Avenue')

I want to somehow then be able to get the primary key - so I then know
exactly which record I have created?

Is this possible? How would I do it?

By the way, I realise I could then do a SELECT statement using the field
values entered but is there an easier/better way?

Angus Comber
ac@NOSPAMiteloffice.com