Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Add a comment to an Icetips ArticlePlease add your comments to this article.
Please note that you must provide both a name and a valid email address in order
for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!
Back to article list Search Articles Add Comment Printer friendly Direct link Par2: Counting records in TPS files 1998-10-26 -- Wesley Coleman Here is something that I have used for record counts with Topspeed Files in
the past. You might test it and see if it would be of any user in your
situation.
Use a build on a dynamic index with filter then use RECORDS(IndexName) to
get the total included in the index. e.g.
OrdMast
FILE,DRIVER('TOPSPEED'),NAME('Orders.tps'),PRE(ORDM),CREATE,BINDABLE,THREAD
ByCustOrder
KEY(ORDM:Company,ORDM:Location,ORDM:CusNum,ORDM:OrderNum),DUP,NOCASE,OPT
ByOrder
KEY(ORDM:Company,ORDM:Location,ORDM:OrderNum),DUP,NOCASE,OPT
ByUser INDEX,NOCASE,OPT
Record RECORD,PRE()
Company LONG
Location LONG
CusNum LONG
OrderNum LONG
LineNum LONG
ShipNum LONG
Name STRING(30)
Address1 STRING(30)
Address2 STRING(30)
City STRING(18)
State STRING(2)
Zip STRING(10)
END
TotalRecords Long
CODE
BIND('ORDM:CusNum',ORDM:CusNum)
BUILD(ORDM:ByUser,'+ORDM:Zip','ORDM:CusNum = 123')
TotalRecords = RECORDS(ORDM:ByUser)
Today is November 21, 2024, 6:31 am This article has been viewed 35221 times.
|
|