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!

  • Congratulations dencom 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: *

  • Users: psperry2
  • Content: Threads
  • Order by date
  1. psperry2

    SourceSafe and VFP 7.0

    A project previously under Source Control is now not acting like it is. I have a project called interview. This project can be verified to be under Source control by starting up the SourceSafe application. I am using VSS version 8.0.50727.42 and VFP 7.0 with SP1 When I use FoxPro to open...
  2. psperry2

    Source Safe problems, VFP 7

    A project previously under Source Control is now not acting like it is. I have a project called interview. This project can be verified to be under Source control by starting up the SourceSafe application. I am using VSS version 8.0.50727.42 and VFP 7.0 with SP1 When use FoxPro to open the...
  3. psperry2

    _mtl_browser

    I have an old VFP application in version 7. When I try to compile it, it fails to compile beacuse it says file _mtl_browser is missing. Where can I get a copy of this file?
  4. psperry2

    Spinner control does not display correctly

    I have an application where a spinner control is used for entering a percentage for later calculations of bonus pay. I have the following proerties set Controlsource p_nPercent Increment 0.25 inputmask 999.99 keyboardhighvalue 200 keyboardlowvalue 0...
  5. psperry2

    Cannot update cursor

    When compiling a project in VFP 7, I get "Cannot update cursor". I have checked and nothing is in use or open. At my company we have 2 versions. We have the Development version - in sourcesafe which compiles just fine. and the Production version - in sourcesafe, which fails to compile with...
  6. psperry2

    3rd party Documentation tool

    My boss has asked me to try and locate a tool that would document the many FoxPro systems we have. And we also need to document a number of VB6 projects as well. All suggestions are greatly appreciated.
  7. psperry2

    COPY FILE

    This command works: COPY FILE "c:\temp\_2iz0i7glg.txt" TO "G:\FOXPROJ\Philip\WorkArea_HumanResources\HumanResources\internal_auditing_data\trash_20081204082920.txt" however the file names are stored in variables and I can't get a foxpro command to work with these variables that actually does...
  8. psperry2

    SQL: Subquery nesting is too deep.

    Here is my SQL statement: SELECT A.last, A.first, A.mpotc, C.clas_Title, A.mdoe, A.sdoe, A.dob, B.h_Salary ; FROM EMP_MAST A RIGHT JOIN EMP_HIST B ON A.SSN = B.SSN AND B.Effect_dat IN ; (SELECT MAX(Effect_dat) FROM EMP_HIST WHERE EMP_HIST.SSN = EMP_MAST.SSN) ; JOIN CLASSCOD C ON...
  9. psperry2

    VFP 7 Getfile() not working as expected

    I am testing new code in VFP 7.0 and when I try to set the OpenButtoncaption and the TitleBarCaption both display as "Do". How can I get this to work correctly?
  10. psperry2

    VFP 7.0 or VFP 9.0 automation with Excel

    I am at the planning stages for a new project. I have been asked to create an Excel Spreadsheet that can be distributed to everyone with a Company Car. (70 + employees) The spreadsheet would allow employees to report personal mileage and Gasoline expenses. We are currently using Office...
  11. psperry2

    Preprocesser Expression is invalid

    When I try to compile this old legacy application, I am getting an error. Compiling g:\sourcesafe\foxpro\production\production_humanresources\libraries\wwipstuff.vcx #IF WWVFPVERSION > 5 Error in line 155 of wwhttpdata.s_execute (record 12): Preprocessor expression is invalid. #IF...
  12. psperry2

    FoxPro table error

    I am working on a VFP7 Human Resources system that has passed thru many hands and many versions of FoxPro. When I try to USE the Emp_mast table, this error pops up repeatedly: Alias 'Emp_Hist' is not found. I click on the ok button repeatedly, then I can finally browse the table. There is...
  13. psperry2

    Moving the checked in VFP project

    We will want to move the code from our various VFP projects to a new network resource. I currently have everything checked into VSS 2005. After the move, what will need to be done to let the VSS project relink with the moved VFP code?
  14. psperry2

    VSS differences

    I have started a new job where I have inherited multiple projects and very little documentation. What I want to do is to put each project (All Visual FoxPro 7) into VSS version 5.0. I have every version of these many projects stored in a WinRAR archive for every release of the software...
  15. psperry2

    Cannot build Project

    I am on my 3rd day on a Job taking over from someone who was terminated last week. I now have a VFP 7 Project that will not compile. I am not yet permitted to make any coding changes. I get this error on the compile: Compiling f:\compcar\companycars\programs\main.prg l_dNotEmpty =...
  16. psperry2

    New to MySql

    I have a lot of experience with SQL Server and transact SQL. Starting Monday I start a new project with MySQL. Can anyone reccommend a book that I can read before the project starts Monday?
  17. psperry2

    Formula change

    I have this formula in a report footer: =Sum([Elapsed_Days])/Count([Elapsed_Days]) What I need to change is to get the count function to not count when the Elapsed Days value is zero. I want the Average to not be wrong because of bad data. I was thinking that some kind of a SQL stmt would...
  18. psperry2

    How to add a total Section to a report

    I have a report that lists Name, startdate, enddate, elapsed days. I need a new section on the report where I can show the average of the Elapsed_days. I currently have a Page Header, detail and page footer section.
  19. psperry2

    Update Query not working

    I need to update a field in a temp table. When I run the Update Query, All I get is a view of the existing field data in the table I want to be updated. No update takes place. UPDATE ztrptElapsed SET StartDate = (SELECT StepDateStart FROM tblPersons_Steps WHERE tblPersons_Steps.ISInvID =...
  20. psperry2

    Sort By Calculated field

    My SQL statement Does not sort by Name. Is there another way to do this? PARAMETERS prmEnd DateTime, prmStart DateTime; INSERT INTO ztrptPendingScheduled ( ISInvID, Name, ContractID, Contract, StepID, StepName, StepDateStart, StepDateEnd, StepStatus ) SELECT tblPersons_steps.ISInvID...

Part and Inventory Search

Back
Top