daveigh
Programmer
- Oct 9, 2003
- 105
Hi guys, im having problems retrieving previous records for a detail page. I have a page:
and i want to show the previous record. I cant use subtraction in order to get the previous record since some of them doesnt fit the filter i made. i get "Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record" error.
sql2 = "SELECT * FROM template WHERE uid BETWEEN "& bawas &" AND shownwhere = 'regular' AND activestatus = true ORDER BY uid asc;"
can somebody help me on this? even a sample code will be very much appreciated. thanks!
_______________CRYOcoustic_____________
and i want to show the previous record. I cant use subtraction in order to get the previous record since some of them doesnt fit the filter i made. i get "Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record" error.
sql2 = "SELECT * FROM template WHERE uid BETWEEN "& bawas &" AND shownwhere = 'regular' AND activestatus = true ORDER BY uid asc;"
can somebody help me on this? even a sample code will be very much appreciated. thanks!
_______________CRYOcoustic_____________