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 strongm 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: KarenJB
  • Content: Threads
  • Order by date
  1. KarenJB

    Index Violation - VFP 9.0

    Hello experts! I am overseeing a VFP application that was purchased from an outside vendor who is no longer available for support. The application has a reindexing procedure that bombs out with a uniqueness of index EMPNO is violated error. I can replicate that error by running INDEX ON EMPNO...
  2. KarenJB

    Retrieving Active Server Information

    thread184-1143741 I am trying to get information from Active server and found this code in the thread shown above: strDomain = "ontario.cnty" && Your own domain name Clear On Error Public PrimDomainContr Create Cursor names (username c(30),fullname c(80),description c(80),Class...
  3. KarenJB

    SQL Pass Thru

    I am trying to gather information from a SQL Database using SQL pass thru. Here is the code that I am attempting to run using VFP 9..... SQLEXEC(lnHandle,"SELECT dbo_OffenderEvent.PersonId, dbo_EventInfo.Comment, dbo_EventInfo.StartDate,; dbo_EventInfo.TypeDescription; FROM dbo_OffenderEvent...
  4. KarenJB

    Traffic Question

    Hello again, We want to put a VFP application on a server that allows users to enter their travel mileage for reimbursement processing. One of the management in our department wrote this.... "You can ask the State but my bet that since it is not a browser based application they are going to...
  5. KarenJB

    SQLeXEC Assistance

    Hello again VFP gurus... I have the following dilemma; when I pass a value of 209475 to this code SQLExec statement number one results in a blank table, SQLExec statement number two works fine. What am I doing wrong? PARAMETERS nID LOCAL lnHandle lnHandle = SQLConnect("CE", "stevemm"...
  6. KarenJB

    VFP exe wont load

    I have a desktop that I'm trying to run two different networked VFP9 apps on. When I launch the one exe it loads fine. When I launch the second one it does not load at all and gives no error message, etc. This second app works fine on 30 other networked computers, just not this specific one...
  7. KarenJB

    Grid Issue

    I have a form with a grid containing 26 rows and 5 columns. The grid has no vertical or horizontal scroll bars because all the information that the user requires is already displayed. I want the grid to be active so that the user can double-click a specific cell to bring up a detail form...
  8. KarenJB

    Mail Merge Problem - VFP 9.0

    I can not get this code to work correctly: #DEFINE wdMainAndDataSource 2 #DEFINE wdSendToPrinter 1 #DEFINE wdDoNotSaveChanges 0 #DEFINE wdWindowStateMinimize 2 oWord=CREATEOBJECT("Word.Application") oWord.VISIBLE = .F. oWord.WindowState = wdWindowStateMinimize oWord.Documents.Open('C:\VFP...
  9. KarenJB

    Inquire only on Database

    I have an application from an outside vendor that is written in VFP. I would like to develop a separate system that would be used to do quick look ups that are specifically written for the users and develop some reports that they could run. What is the easiest/best way to access that database...
  10. KarenJB

    Gathering SQL data efficeintly

    I have a remote view that will display all clients and an admission date in a grid. That part was easy using only two SQL tables and approx 8 fields. What I'd then like to happen is have the user double-click on a grid entry and the application access the rest of the data that is linked to that...
  11. KarenJB

    Invalid form

    When I try to modify my form I get this message: Error loading file - record number 15. FRMCLIENT <or one of its members>. User properties : Memo file c:\vfp\projects\frmclient.sct is missing or invalid. frmclient.sct is not missing so I'm assuming it is invalid. Is there anything I can do...

Part and Inventory Search

Back
Top