P10 WinXP
An indexed table with 3 fields. The 3rd field is a checkbox field which has
a "Y" when checked.
The table is presented as a tableframe on a form/
The user clicks on the fields he wants included. I need to count the # of
records to be used

siCount = 0;// set counter
TC2.edit()
If not TC2.lockRecord() then
errorshow()
ENDIF
If not TC2.postrecord() then
errorshow("Could not post TC2 record")
return
ENDIF


Scan TC2 for TC2."Checkbox" = "Y":
msginfo(TC2."ClinicalCode",TC2."CheckBox")
siCount = siCount +1
ENDSCAN

The reason for the lockrecord is because it wouldn't postrecord() because
the record was not locked.
It always skips the last checkbox. Why?

Thanks in advance

Craig

Craig wrote:

Have you tried doing a query instead? It may be just as fast, or
faster, than a scan for this. Or, you could put a secondary index on
CheckBox, then do a setRange(), then tc.nRecords().

Craig

Where is tc2 opened or attached?

If you have attach tc2 to a uiobject in your form, a tc2.postrecord() or
tc2.unlockrecord() won't post/unlock the editing made in the form. That
record will still be locked. You have to unlock the record used in your
form. And that cant be done with the tcursor.


--
Bertil Isberg - CTECH
Paradox buglist:
online: http://hem.bredband.net/bertilisberg/

"Craig" <craig.futterman (AT) nospam (DOT) comcast.net> skrev i meddelandet
news:45be36d9$1 (AT) pnews (DOT) thedbcommunity.com...

Bertil,
Yes, you are correct (yet again....)
I opened the TCursor (TC2) when the form opened.
I changed it to UI.postrecord and it worked beautifully!!!

Thanks,
Craig Futterman

"Bertil Isberg" <ctech (AT) corel (DOT) ca> wrote