Board index » delphi » ADO append / post in Access

Stig Norland

Delphi Developer
Sun, 26 May 2002 03:00:00 GMT

ADO append / post in Access

Hi just a short question

When you do an append .... post command against a Access dB
and you want to retrieve the new UID for this record
what is the best way of retrieving it ?

(the UID would be a access autonumber)

Stig

-----
Tempus omnia revelat

Stig Norland
Software Developer
LOOPsys
http://www.loopsys.com

 
Thomas B?g

Delphi Developer
Sun, 26 May 2002 03:00:00 GMT

Re:ADO append / post in Access


Try

INSERT INTO <TABLENAME> (Field1, Field2) VALUES (Value1, Value2)

/Thomas

Quote
Stig Norland <s...@anonymous.net> wrote in message

news:82llld$hcv5@forums.borland.com...
Quote
> Hi just a short question

> When you do an append .... post command against a Access dB
> and you want to retrieve the new UID for this record
> what is the best way of retrieving it ?

> (the UID would be a access autonumber)

> Stig

> -----
> Tempus omnia revelat

> Stig Norland
> Software Developer
> LOOPsys
> http://www.loopsys.com

Stig Norlan

Delphi Developer
Sun, 26 May 2002 03:00:00 GMT

Re:ADO append / post in Access


Quote
Thomas B?ge <no.Junk.thomas.bo...@get2net.dk> wrote in message

news:82lq87$hho3@forums.borland.com...

Quote
> Try

> INSERT INTO <TABLENAME> (Field1, Field2) VALUES (Value1, Value2)

> /Thomas

What I was looking for was  a:
             append:
             ...
             post;
             try
                refresh;
             except on e:exception do
            ...
            UID := FieldValues['UID'];

I had some problems with the refresh method,
but after some tweeking I fixed it...

Tanks
Stig

-----
Tempus omnia revelat

Stig Norland
Software Developer
LOOPsys
http://www.loopsys.com

Other Threads

1. Memory leak with ADO dataset and append/post

2. Ado Append / Post does not work

3. ADO and MS Access Append Query????

4. Bug in Delphi when posting/appending records?

5. Error deleting a record after it is appended and then posted

6. Append and Post problem

7. IDENTITY Using Append and Post

8. generators, ibtable - Insert via SQL works , append/post doesn't

9. 3rd DBase append/post gives General Read Failure from BDE

10. Posting - not in edit or append mode.