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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. trick66

    VFP7 application crashes after idle on 2003 server

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

    Optimizing function for quick output

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

    Optimizing function for quick output

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

    Delete orphaned records

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

    Delete orphaned records

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

    VFP7 Application running slow after upgrading server to 2003

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

    VFP7 Application running slow after upgrading server to 2003

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

    list all tables that have a certain field in it

    Thanks all, these are very helpful information. Rick
  9. trick66

    list all tables that have a certain field in it

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

    VFP7R.DLL is invalid or damaged

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

    Browsing a Table for Duplicate Records

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

    Browsing a Table for Duplicate Records

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

    Return last value from a table with certain conditions

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

    Return last value from a table with certain conditions

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

    Return last value from a table with certain conditions

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

    Return last value from a table with certain conditions

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

    VFP print command for MS Works

    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 =...
  18. trick66

    Getting field value from table that is not open

    If you don't know already, I am not a programmer, so please be patient with me. I do know what field name that I need, along with the table name. My GetField expression was this: GETFIELD('WOSEQ','STATUS','WO_NO',WO_NO) According to my knowledge, this is grabbing the field name STATUS from the...
  19. trick66

    Getting field value from table that is not open

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

    VFP6R.DLL error

    The strange thing is that it is only occuring on two workstation, where others are fine. I have the latest Novell client installed the and the application was written in VFP 6 SP 5.

Part and Inventory Search

Back
Top