Record count of conditionally indexed dbf

[angelos at nospam.accpick.co.za]

Is there a way to get a record count of a conditionally indexed
database in FS?
ie. What is the fastest way to see how many records meet a specific
criteria, Example - need to scroll through all stock items with < 0
Qty on hand and load them into an array. I would like to be able to
show an accurate progress bar whilst doing the scroll through the
file.

cTempidx := 'temp_index_name'
Use stock
nTotRecords := reccount()
index on code to &cTempidx for qtyonhand < 0 nolock
nIndRecords := ?? Is there a way to get a record count of the items
that met the Indexing criteria about??

Any suggestions?

Angelos

[Paul]

On 18 Jun., 15:19, "angelos at nospam.accpick.co.za"

nIndRecords := OrdKeyCount() // see the FlagShip VFS7 on-line
manual
// section FUN for details.

// An alternative is
nIndRecords := DbObject():OrderInfo(DBOI_KEYCOUNT)
// see the VFS7 manual section OBJ.DbServer:OrderInfo

> Any suggestions?
>
> Angelos

see above. Hope this helps you.

Paul

[Angelos Christodoulou]

Gee - thanks for the prompt response!
Will give that a try and reportback on my findings

Really appreciate the suggestion

--
You received this message because you are subscribed to the Google Groups
"multisoft FlagShip" group.
To post to this group, send email to multisoft...@googlegroups.com.
To unsubscribe from this group, send email to
multisoft-flags...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/multisoft-flagship?hl=en.

-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2180 / Virus Database: 2433/5076 - Release Date: 06/17/12

[Angelos Christodoulou]

Worked perfectly - thanks!

-----Original Message-----
From: multisoft...@googlegroups.com
[mailto:multisoft...@googlegroups.com] On Behalf Of Paul
Sent: Monday, June 18, 2012 4:28 PM
To: multisoft FlagShip
Subject: Re: Record count of conditionally indexed dbf