Recent content by trick66

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...

Sorry, I forgot to mention that this is for VFP7. Rick

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...

Sorry for the lack of information. It is VFP 7. But what Mike Lewis gave me worked. You guys are great, thanks again. Rick

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"...

Thanks, Rick. the entire application along with data are stored on the server. The only files that are on the workstations are the DLLs and some OCX. Rick

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...

Thanks all, these are very helpful information. Rick

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...

Thanks for the suggestions Kilroy, but I tried the search before I even posted. None of the tips showed me how to BROWSE the duplicate records. Maybe I'm missing something. Rick

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...

You guys have been great help. I was able to modify each suggested code and combine them and got it to work. Although it may not be the orthodox was of doing it. Thanks for all of you guys help. Can any one show me how to add that code box in my post? Rick

Kevin, Thanks for the advice. But that is the code that I tried. Rick

Mike, Thanks for the info. But when I try to compile it, I get an error message: "Command is missing required clause." for the INTO CURSOR... line. BTW, I am using VFP 6.0 to compile. I ignore the error message and applied the compiled function to the report, but I also get the same error when...