Re: WHERE COUNT = LAST

[Ben Weeda]

Buddy, Bill, Lawrence and Razzak,   Thanks for the fast reaction on my question. It sure is good to have a list like this!   Ben Weeda ----- Oorspronkelijk bericht ----- Van: Ben Weeda Aan: [EMAIL PROTECTED] Verzonden: woensdag 22 augustus 2001 21:23 Onderwerp: WHERE COUNT = LAST Hello,   In R:Base and Oterro you can use WHERE COUNT = LAST to select the last record that you added. For instance to read the ID-column that R:Base assigned to a record if the ID is AUTONUMBER. Is this standard ANSI SQL, or is it a plus that R:Base gives you? I couldn't get it to work in a SQL-server 2000 database.   Yours   Ben Weeda