Thanks for the replies, to answer your questions the file I believe finished the problem lies in not being able to open the resulting file which is 1.7gb, 3325571 line each being 532 bytes long. I am now trying to find a editor that will open the file in mangable chunks. Unix I believe has the...
Is there a limitation to how much you can write to a text file from FoxPro 2.6? I am try to export some data the line count will be approximately 3 million lines written out using low level file IO. I started and it seems to stop at 299,000 lines. Could this be the editor I trying to open the...
We are connected through a switch, many issue resolved by moving to windows 2000. We are destined to maintain the foxpro 2.6 app for at least the next year to 18 months. So if you have feed back we'll listen.
Thanks in advance
Perl
Perl
Forum-Financial.com
I'm working on an app built in FoxPro 2.6 in the project there are several Dialogs, Screens, Menus and Programs. There are a couple of dialogs that show up twice and I'm not sure why. The dialog(d_blah) shows up in the project as a screen set and a program. The edit screen set dialog has the...
Covered index are index that contains in its structure more information than the index key. For example if you have a query:
select name from custumers where birthdate beetween '01/01/99' and '01/31/99'
a simple index will be created containing birthdate column. A covered index will contain...
I agree, Huh?
The data is being queried into temporary tables, accounts in one and transaction inthe other.
so if you have 5 accounts with transaction each it would look like:
name
addr
a1
a2
a3
a4
a5
a1 start
t1
t2
a1 end
totals
a2 start
t1
t2
a2 end...
Tried and tried, turn out it may have been getting overloaded. This is the scenario that breaks it. Start with the account record set that is 15000+ than get he related transactions 190000+ now the report puts n accounts into a group header as a customer may have multiple accounts. Then the...
Thanks Dave
Your solution was right on only issue I had, and I believe it is because I am no sending exact numbers to the print job, is I added:
IF (!EOF())
SKIP
ENDIF
Again I am saying NEXT maxrecs, so for a record set of 11000
I do two interation and the second one say NEXT maxrecs...
The early results have proved not to be consistent, thus the consistency error - Oh well. The problem seems to have hidden for a moment but when the job is in preview we were able to get through the reports. When trying to send to the printer the error ocurred again. Could it point to memory...
Dave so from the above code, am I correct in that the _PAGENO is limited so the UDF will insure a proper page count is reported and the DO WHILE !EOF() will call the report and print in burse of 1000?
Perl
Forum-Financial.com
I have seem many threads on this but none seem to exactly fit. Have a report in an application we are using that is printed every month. It prints base on a client type. Some client monthly statements print each month others fail.
The print driver has not changed, the indexes have been re-built...
I am printing a report in a fox 2.6a application the report has 11170 pages. In preview mode the report is displayed fine all pages. When print mode is selected the report stops at 9999. Is there a setting? I looked at the _PEPAGE and it is set to 32768. My thoughts are to split the record set...
I have a report that is supposed to print a the header on each page it seems to work fine but every once in a while it skips a page then prints it back at the top of the subsequent page. Any ideas? I think when the detail line prints below a certain point on the report is when it occurs. The...
Have you tried the suggestions by fluteplr yet?
Yes, we have done what fluteplr said except for relocating the executable. This is a next step, if nothing else produces results.
Is your network still at running at 10 Meg or have you upgraded to 100 Meg yet?
Upgraded to 100, although in at least...
Thank you all for your comments and suggestions.
We have not upgraded because of some setbacks. A java solution is in the works but we are looking at several months before this becomes available.
The hardware and software have been upgraded. Various networking changes have been made and a...
We are using FoxPro 2.6b and Tom Rettig Office(TRO)
The TRO is a foundation product that we used as a starting point for the system. The system has grow to a point where the performance is critically slow when more then one user is logged into the system. The number of user logged in at any one...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.