Hi, i need to know the Next() and Prev record for a navigation toolbar
with a SQL sentence.

GetFirstID()
  SELECT TOP 1 PK_Field FROM Table WHERE Field='00001'  ORDER BY Name
GetLastID()
  SELECT TOP 1 PK_Field FROM Table WHERE Field='00001'  ORDER BY Name
DESC

I im actually developing in VFP, sry for asking here.

Reply via email to