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.
