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

Foxprow 2,6 on NT "Insufficient Memory" error

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
0
0
I have a Foxpro for Windows 2.6 application running on an NT workstation with 900 records in two files one of which has a memo field, and a large linked transaction file of 100,000 records. All of these are open when updating records. Occasionally (and at the moment on one record) it reports Insufficient Memory and damages the file with the memo field which is being updated.

Reading round it seems that FPW does have problems with more that 600 records on fast machines, although it seems hard to believe. Or is it a memory management problem? Any help would be appreciated.
 
table name is att_unit fields are:
student_id c 10,staff c 4,program c 4,week_no n 3,0, week_dte d,end_dte d, cycle c 6, after_hrs n 1,0 ,su_att c 2,su_coord n 3,0, su_miles n 5,2, SU_log1 thru su_log5 c 6 the remaining fields are as above for remaining days of week M_ , T_, W_, TH_, F_ , SA_
Indexes are: student_id,week_no,week_dte,program then
week_no desc tag week_desc, str(week_no,3,0)+alltrim(student_id) tag weekNO_sid, alltrim(student_id)+str(week_no,3,0) tag sid_week
The code where i browse this table is:
set order to week_desc
goto top
set near on
set filter to &filter_id (which is the student_id)
on key label rightmouse keyboard chr(23)
on key label ENTER keyboard chr(23)
define window PICKIT from 02,01 to 34,76 close title 'To Select ...etc etc' system
brow window pickit fields student_id :H='STUDENT',;
week_no :h='week#',week_dte :h='STARTS', program :h='PROGRAM', su_att :h='S', m_att :h='M',;
....(thru SA_ for saturday) NOEDIT
Now when scrolling up and down in this window the system hangs up. Would appreciate any help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top