Find Max(RecID)

[Ruslan Zasukhin]

On 5/15/04 5:05 PM, "RyHoRuK" <RyHoRuK at gmx.de> wrote:

> Hi,
> 
> is this the fastest way to find in a table the max(RecID)?
> 
>  SQLString="select RecID FROM Konten WHERE Konto_Typ=1"
>  CurKontoCheck=meineDatenbank.SQLselect(SQLString, kV_Server,
> kV_NoLocks, kV_Random)
>  res=CurKontoCheck.LastRecord
>  MaxRecID=CurKontoCheck.ulongField("RecID").value

I think no.

taking into account that last LOGICAL record in Valentina table
Always is last PHYSICAL you can try do next

    BaseObject.LastRecord
    macRecID = BaseObject.RecID


But this is for LOCAL dbs only.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------