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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

screen errors out after 6th record in dbf

Status
Not open for further replies.

MJJ

Programmer
Jul 27, 2000
13
BH
Hi All, hope I can get some more help ... I'm using fpw2.5 & a dbf w/about 1500 records. I built a screen using screen builder and added some buttons to "proceed to next record", "go back to previous record". When I run the screen & advance records, it always errors out at record 6. The error is "Too many READs in effect".
The screen contains fields (8 character & 2 memo). Both memo fields & 6 of the character fields must be edit-able.
The end result needed was a "datashow" type of display for clients to review & change some data while reviewing. Maybe there's a better way to do this instead of a screen? For now (since the need was immediate) I just ordered/browsed the fields required.
Thank you for any input! [sig][/sig]
 
It sounds like you might have an extra READ statement in your code that is executing each time you press the Next Record button. Reads are limited to 5. You don't want to execute but one READ statement. [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href= - Visual FoxPro Development</a><br> [/sig]
 
Inside your screen, somewhere in a procedure you wrote or call, you must have a read statement(s) not added by the screen generator..

Solutions
1. Find them and remove them. (recommended solution)
2. Call a routine that clears all reads in all the screen procedure you write or call

Procedure clearead()
clear gets
clear read
clear read all
return [sig]<p>David W. Grewe<br><a href=mailto:Dave@internationalbid.net>Dave@internationalbid.net</a><br>[/sig]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top