Find Max(RecID)

[RyHoRuK]

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


bye


Claudius

-- 
G4/733 QS / MacOS X 10.3.3de / RB 5.2.4de or 5.5.1de/ Valentina 1.10.0
Homepage    http://www.sailer-online.de/pub/RealBasic/
Download    finale Versionen, Betaversionen auf der Homepage
RealBasic ListBoxes: [ I feel the need...the need for speed!!! ]