Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Avaible records and a grid problem 2
- Thread starter DannC
- Start date
-
1
- #2
ChrisRChamberlain
Programmer
nefra
Q1
? RECCOUNT([TABLENAME])
or (moves pointer but goes back to original record)
lnRecno = RECNO([TABLENAME])
COUNT FOR expr TO lnTotal
GO lnRecno
? lnTotal
Q2
FAQ184-426
Chris
Q1
? RECCOUNT([TABLENAME])
or (moves pointer but goes back to original record)
lnRecno = RECNO([TABLENAME])
COUNT FOR expr TO lnTotal
GO lnRecno
? lnTotal
Q2
FAQ184-426
Chris
-
1
- #3
Q1
Note that RECCOUNT() is not affected by SET DELETED or SET FILTER TO.
Using a SELECT - SQL, that's quite easy to do; for example:
Obviously, the same can be done using the COUNT FOR, as long as one doesn't forget to put the record back.
Diederik Vermeeren
verm1864@exact.nl
Code:
SELECT COUNT(*) FROM [tablename] INTO ARRAY aList
? "No. records = " + STR(aList[1]Note that RECCOUNT() is not affected by SET DELETED or SET FILTER TO.
Using a SELECT - SQL, that's quite easy to do; for example:
Code:
SELECT COUNT(*) FROM [tablename] WHERE !DELETED() INTO ARRAY aListObviously, the same can be done using the COUNT FOR, as long as one doesn't forget to put the record back.
Diederik Vermeeren
verm1864@exact.nl
- Status
