>A old 2.5 app Im migrating to (and merging with a current) 5.0 app uses RECNO()'s for searching/printing. For Example: goto firstno; STORE LASTNO-FIRSTNO TO NO; STORE NO+1 TO NO; REPORT FORM C:\FOXPROW\concrete\dotplace.FRX NEXT NO TO PRINTER NOCONSOLEWhich works, at least in the 2.5 program.I want to mimmic this behaviour (using RECNO()'s) but calling a form with a summilar REPORT dosent seem to work, and trying to populate a view with a filter condition of RECNO() BETEWEEN (first, last) dosent work either.Im definitly going to have to use RECNO for the old data (its actualy on the printed reports), so this is realy my only option.
The Recno() of a view need not be the same as the REcno() of the underlying table, specially if there's a Where clause. You may be better off (if a view is a must) to use something like
Select *, recno() as rcn from OriginalTable
in your view definition, and replace references to RecNo() with Rcn; maybe you should index by Rcn to achieve original ordering of records. I know this is a kludge, but if the original tables are designed so, it takes a kludge to emulate the behavior.