WHERE COUNT=LAST returns the last record ANYONE has added. WHERE COUNT = INSERT
returns the one YOU added.
"Ben Weeda" <[EMAIL PROTECTED]> wrote:
>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
>
__________________________________________________________________
Your favorite stores, helpful shopping tools and great gift ideas. Experience the
convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/
Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
