Visual FoxPro

Page 212




  • Topics
    Replies
    Last post
  • Using a JOIN when communicating with SQL from VFP6
    by mrfitness
    4 Replies
    Last post by Alex Feldstein
      • I created two programs in which both connect to SQL database to execute a SELECT query. The first one is a straight forward one with one table and works fine when I display info SQLEXEC(m.lnConn, 'SELECT * FROM Cluster_info', 'cinfo') scan cinfo.cluster_name The second one is trying to JOIN a table and a view. I first went into SQL and used the query view to select and join my table/view to automa
  • Open table exclusively?
    by rroot01
    14 Replies
    Last post by AndyKr
      • Forgive my ignorance - I've recently reinstalled XP and subsequently Foxpro 7.0. Now when i double click on a foxpro dbf file it opens the table and another datasession labeled 'B' (i'm supposing it's a datasession). Previously, when i opened a table i was in exclusive mode and didn't have this duplicate table open also. I normally work in exclusive mode because my data is not in a shared environm
  • How to create a calendar in report?
    by Lightening
    9 Replies
    Last post by Naomi Nosonovsky
      • Trying to create an event calendar in VFP6 report Have a table with 2 columns, cText, dDate Created a group based on Week(dDate) -- group by every week. Add 7 fields for dDate value across a row, with each like iif( dow(dDate)=1, " "+SUBS(DTOC(DDATE),4,2) +" Sunday","") iif( dow(dDate)=2, " "+SUBS(DTOC(DDATE),4,2) +" Mon
  • Problem with Vista Windows mail
    by JackChiou
    14 Replies
    Last post by Naomi Nosonovsky
      • Hi everyone, We have this foxpro 8 program that getting email from Outlook 2000, 2003, 2007 with MAPI32. It works fine until we try it on Vista's Windows mail. Everytime it runs "fetch" and get the meesage, the program will just break and pop up an error message saying "An error occurred communicating with your MAPI message system. If you are using Microsoft Outlook try ch
  • Returning Arrays And Cursors to .NET from VFP???
    by AlexBB
    14 Replies
    Last post by CetinBasoz
      • It is all about the business of Stored Procedures which I am trying to perfect. The SPs are called by my .NET C# app. A lot of the stuff I've had difficulaties initialy appears to be working now. Still there are numerous limitations and one has to get used to them. It is a new style of programming. Very austere. If you want to DELETE a record in a table and you have 15 of them and want to determin
  • Combobox too short, no show of element
    by Hans L
    6 Replies
    Last post by Hans L
      • I had a combobox that was shorter than some elements in the list. The longest of them did not show in the box at all. I had to lengthen the combobox in order to show this longest element. Is this a know glitch Hans L
  • Application reinstall using install shield.
    by Aleniko
    9 Replies
    Last post by Rick Borup
      • Hi; I have created a setup program with the install shield supplied with VFP9. Install went OK, but then I realized I need to have some additional files like the runtime libraries etc. On the second try, Installshield wants me to remove the old installation using ADD/REMOVE from control panel. The problem is that I cant find the installed program anywhere in the add/remove programs. I am also not
  • How to control the scanner with VFP?
    by hoabinh
    5 Replies
    Last post by AndyKr
      • Hi everyone, Could I build a program in VFP to control my scanner as: connect, scan, and save file.... Where could I find out the TWAIN OCX support for it Thanks a lot.
  • vfp desktop app redesign/rebuild as aweb application
    by maryg
    3 Replies
    Last post by Claude Fox
      • I need some help with figuring out how to port a desktop application to a web application given these constraints: 1. Desire to maintain a base of common code between desktop and web applications 2. Desktop code is mostly procedural, not object-oriented (originally written in FoxPro 2.6), and does not separate interface from business logic. 3. Preference to make as few changes to desktop code as p
  • "Cannot find the menu-generation program."
    by AlexBB
    14 Replies
    Last post by AlexBB
      • Hi there, I actually posted on this subject twice before and once got a satisfactory answer, the other time I simply figured out how to get this file myself. Now it seems to be different. When I make and attempt to build a project I get this message. So, I click Add, go to Program Files\Microsoft Visual FoxPro 9\ and find a file: genmenu.prg . Click on it and I get another error message:
  • NOT A TABLE
    by NGUYEN XUAN KHANH
    4 Replies
    Last post by Vladimir Zografski
      • RECENTLY I HAVE A TERRIBLE PROBLEM ABOUT DATABASE IN VISUAL FOXPRO 8. THERE ARE 400 DBF FILE IN MY DBC. 2 DAYS AGO, AFTER INPUTED DATA, I EXITED THE APPLICATION. THE NEXT MORNING I RAN THE APPLICATION, IT MESSAGE TO ME THAT "NOT A TABLE". I CHECKED AND FOUND THAT 300 DBF FILES GOT ERROR "NOT A TABLE". ALTHOUGHT MOST OF THEM WEREN'T INPUTED DATA AND POWER AND HARDWARE WERE IN GO
  • Qick Sql question
    by Brad McCormick
    4 Replies
    Last post by CetinBasoz
      • Good Morning Everyone, Quick question, how can i use a variable with a like statement as in select * from table where col1 like var
  • How to copy one column to another
    by gdtrfb
    4 Replies
    Last post by CetinBasoz
      • Hi all, I would like to copy a column that has prices (fprice) for parts in it to another column within the same table.  Then I am going to do a replace on the original column (fprice) to increase the price by a fixed amount (I know how to do that).  The table has a column that is not used for anything (by us) within the application.  It is a User Character 3 field (fcu
  • Open Source VFP?
    by Claude Fox
    12 Replies
    Last post by Tamar E. Granor
      • Ok, this article looks fairly balanced and states that MS is seriously considering an Open Source VFP!: http://arstechnica.com/journals/microsoft.ars/2007/04/03/developers-petition-for-the-return-of-visual-foxpro
  • C++ to VFP Translation?
    by Cody King
    14 Replies
    Last post by CChalom
      • First, I'll have to admit that my coding skills have been unused for several years now, but this is one thing I believe that VFP should handle no problem. Here is the setup: This program gets data from an A to D board and it utilizes DLPORTIO.DLL to address the parallel port and go thru 8 channels. (I know.... old school...but that's why I got it!) I've done the Declare statements t
  • VFP6: Problem saving data
    by MillBear
    6 Replies
    Last post by AndyKr
      • Hi all The VFP database system is running in the server so that all the workstations can share it. The user complained that she could not save the data after amending. I tested to see whether I was able to save it on my side. It works successfully. I went back to the user¡¯s workstation to verify it but still the same problem. I tried other workstations and found no problem so far.
  • How can I make a Singleton (i.e. can create only a Single Instance at a time) application in VFP 6.0 ?
    by nrpanda
    7 Replies
    Last post by nrpanda
      • Hi, How can I make a Singleton application in VFP 6.0. A Singleton application means only one instance can be created at a time of an .exe from its source folder. I have tried to make it through checking the flag value stored in dbf field. If True, then exe is running, else not. It is working fine. But when I am running the myapp.exe file second time, it is flashing its background scr
  • program line numbers...
    by ibbm
    3 Replies
    Last post by ibbm
      • how do you display the code line numbers when you are trying to locate the errors when building an app. It used to be in the debugger but I don't seem to be having much luck!
  • Historical FoxPro
    by Dumarest
    5 Replies
    Last post by Dan Freeman
      • This is really historical, back when FoxPro was independent. I just had a full system crash, and now want to get my one database with FoxPro back up. It will not run. Calls for a dll which is in fact on the system, but indicates that reinstalling the .exe file is desired. But ...... That is years ago, and any source material is on 5 1/4 inch diskettes if I still have them [generally these have lon
  • Update multiple records in remote view opened with NOREQUERY causes error: File is in use by another user (Error 108)
    by WallyN
    2 Replies
    Last post by WallyN
      • I am in the process of converting to SQL using remote views. The application opens up many tables, in many data sessions so to keep from downloading the same data over and over again I have used the NOREQUERY option of the USE command. This works great if I am in the same data session; however, if I open the same remote view in a different data session and then try to update multiple records it ca
  • FOXFIX5.DLL and Windows 2003 Server
    by Stuman99
    9 Replies
    Last post by Stuman99
      • I seem to be having a problem using foxfix.dll on a windows 2003 server. The error message generated is cannot load 32-bit dll c:\foxfix\foxfix5.dll. Any ideas... seems to work ok when run from my windows xp workstation. Stuart
  • How to disable Foxpro screen?
    by Joe Au
    14 Replies
    Last post by AndyKr
      • I have a project with one screen form only. When I run the execute, the screen form is within the foxpro's screen. How do I make the screen form as the only window form shown on screen Thanks. Joe.
  • Report Designer
    by MillBear
    3 Replies
    Last post by MarciaAkins
      • Hi all Is there date sorting on the field in the report designer Thank you.
  • Corrupted Table after attempting inserts.
    by Kadrin
    8 Replies
    Last post by Naomi Nosonovsky
      • Hey everyone, You may have read my post the other day about inserting records into a table, well I did get that sorted out. However, once I finished the insert statements I put them into a DO WHILE loop and had it working yesterday before leaving the office. Today, I am having difficulties, there was an error when I ran the INSERT s , it said "End of File Encountered". The expression o
  • Little Doubts with ListView....
    by Paramu
    5 Replies
    Last post by Markish
      • Hi There, Well. & Thanks in advance. Actually I added a table data's to Listview...But I want to locate my cursor in Listview ...according to my Textbox...value... for that any Command same like Locate for.... My Codings...For Data's added in ListView.. ---------------------------------------------------------------------------------------------------------------