Search results for query: *

Help, This should have been a simple process of setting the CLOCK to OFF in the config.fp file. But of course the simple things are never that simple. I have a FP 2.6DOS application set where the code does NOT have a "SET CLOCK ON" statement. I need to force all called FP sessions to have the...

I am agreed that FPD cannot reach out and get the PID nativly but the tasks I have issues with are launched from BAT files. If I have the process Id of that DOS session I can write it out to a log file within the BAT and use that data to later determine which tasks are not closing out...

I an running scheduled jobs on a Windows server that launch a FPD 2.6 session and there are a few NTVDM sessions that hang. Our process logs say that the jobs all ran to completion but we still have the system processes running and taking up resources. Some jobs are BAT files and some are...

I have a production system where we cannot PACK a table without archiving the deleted records. We have to maintain for a minimum of 3 years. Does anyone have any recomendations on a procedure to handle these archives? I can always write a routine to SELECT the deleted records to external...

Ok, the problem seems to be just raw query processing limits. I ran the original query using local tables and it took 285 seconds. I removed the non-index component and it took 255 seconds. I split the query into seperate queries and it took 244 seconds to get the first result. Either way...

Ok, I ran a DOS copy of the main table from the query and I get a 6.5M/sec transfer rate. The queries are using single field indexes with only one non index field in the query, brctype. Last run took 16.3 minutes to complete. BRC - create_dt - index BRCITEM - ordernum - index select...

I have a 1.2G DBF that has to be queried daily and the SELECT is taking forever to run. I move all temp and work pointers to local folders and got a performance gain but when I monitor the network interface I see that it is maxing out at 2.2M/sec. I tested the connection my performing a...

Thnaks for the feedback. I had to write a parser to pull the needed data byte by byte. The file had no CR or LF so I had to scan each byte to find the tag starts and treat it as a new line then process previous line for wanted data. Not pretty but did the job. Jon

I have been asked to parse XML files and pull elements out into a Foxpro DBF file. Is there a "simiple" method of doing this? I do not have many rights to load utilites in this network and have to work with what I have. Windows XP MS Office Foxpro 2.6 DOS Jon