Search results for query: *

Several of my clients are reporting that a VFP7 application, that I support, is crashing after being idle for some time. The application in question is installed on a Windows 2003 Server computer along with the DBFs. The Windows XP workstations only have the runtime files with a shortcut to the...

I have the below function that takes quite long to run on a report. Is there a way for me to optimized it to perform the query quicker. I appreciate any help anyone can give me. Thanks. Rick PARAMETER HID,STW,STL LOCAL F,RECTRANS F=ALIAS() RECTRANS='' SET OPTIMIZE ON SELECT...

I have a number of tables that all belong to a single database. One of the tables, ROUTNO, is considered the "header" table which has ROUT_NO as an index. The other tables also have ROUT_NO as an index. What I want to accomplish is to create a command that will delete records from the "minor"...

I am trying to resolve some performance issues with a VFP7 application that is stored on a Win2003 server and being runned on XP workstations off of a shortcut directed to the server. Unfortunately, I do not have direct access to the programmers who built this application to get answers. The...

I have a production control software that I need to find out which tables have COMP_ID as one if their fields. I know that there are a few tables that have this field name, but I would like to make sure that I get all of them and not miss anything. Is there a command that can be run in VFP7 if...

An end-user of a VFP7 application recently upgraded his computer to Win98SE. Since then, he has not been able to start the application and keeps getting "VFP7R.DLL file is invalid or damaged". Everyone else does not have this problem, and are running on a mix of OS (W2K, WXP, W95b) Here is what...

Ok, I've search for tips on duplicate records, but none actually tells me how to browse the duplicate records. I would like to be able to browse a single table for duplicate records either based on a few fields or every fields. The reason I want to browse is because I would like to be able to...

I need assistance with creating a function that will return the last date value from a table that fits two conditions. This is what I have so far: PARAMETER RTNO LOCAL F,DBFTRACE F=ALIAS() RETVAL='' USE DBFTRACE ORDER TAG ROUT_NO ASCENDING IN 0 ALIAS DT AGAIN SELECT DT SEEK RTNO SCAN WHILE...

Please help, I am trying to modify VFP app to print attached WORKS (.XLR) files. The app can handle EXCEL (.XLS) files, but does not have the command for WORKS files. Here is the command that controls the printing of EXCEL file: FUNCTION PRINTEXCELDOC LPARAMETER FILENAME OEXCEL =...

Please help. I am trying to get grab a field from a table onto a report, but the table is not open. I tried to use GETFIELD, but the values were not correct. Is there any other options to take? Rick

I am running a Visual Foxpro 6.0 application on a Novell Netware server and am getting errors when I go to a certain area of the application. The error reads: V has caused an error in VFP6R.DLL V will now close. If you continue to experience problems, try restarting you computer V caused an...

I am running a Visual Foxpro 6.0 application on a Novell Netware server and am getting errors when I go to a certain area of the application. The error reads: V has caused an error in VFP6R.DLL V will now close. If you continue to experience problems, try restarting you computer V caused an...