Visual FoxPro

Page 86




  • Topics
    Replies
    Last post
  • Missing variable _HELPWEBSEARCH
    by GeofS
    2 Replies
    Last post by GeofS
      • I've compiled a VFP6 application with VFP9 without a problem. However, when the app starts up I now get the error "Variable '_HELPWEBSEARCH' is not found." This name is used in the definition of a menu item that opens a Web page. Why can't the program find that name Has it changed in the evolution from VFP6 to VFP9
  • Exporting Data to a text file.
    by Dohko
    7 Replies
    Last post by Alex Feldstein
      • Hi I need write a program that looks at a table and returns how many times an entry appears on the table. I created a DBF file with one table that has some numbers 1 to 51. I would like to know how can I create a text file that tells me that 1 appears 30 times, 2 appears 32 times, 3 appears 6 times, and so on. Thanks
  • Comparing VFP table Records with an Oracle database table
    by kuuku
    1 Replies
    Last post by AndyKr
      • I have table AB which is a VFP table and table CD which is in an Oracle database. Is it possible to compare the records in table AB with that of table CD and then create a new table in VFP for the records in AB not in CD using VFP and if so how is it done
  • Thumbnail -Images
    by MM ROy
    10 Replies
    Last post by MM ROy
      • Sir, I am using Visual FoxPro 6.0 version. I want to view (like thumbnail) all the images of a folder (.jpg, .gif, etc.) using with visual foxpro form. The number of images may be varying. I have no idea....Please help... Roy MM
  • Help with code for updating table on website
    by Jim Holloway
    10 Replies
    Last post by Stuart Dunkeld
      • This is the code I am attempting to usw to add/edit date in a free table on my website. It opens the table fine and will display what is already in the table, but any changes I try to make do not arent being saved. I dont get any errors. Any help USE \\www.infotizer.com\lotterydata\NewData.dbf SET SAFETY OFF SELECT NewData INDEX ON state TO IdxState SET SAFETY ON SELECT StateLinks SET ORD
  • Code in VFP9 runtime application scrolls on screen.
    by Derek Dowle
    3 Replies
    Last post by Naomi Nosonovsky
      • I have a routine in an application to export data to an Excel Workbook that runs as designed in the development environment but not in the runtime environment. When exporting data there are two particular errors that need to be trapped. The first is when the name of the file already exists. In this case VFP appears to be able to resolve the problem automatically, without the n
  • Southwest Fox 2007 Speakers and Sessions Announced
    by Rick Schummer
    0 Replies
    Last post by Rick Schummer
      • The crew at Geek Gatherings are pleased to announce that speakers and sessions have been selected for Southwest Fox 2007. This is shaping up to be a must-attend conference this year. Registration is now open. Be sure to take advantage of the early-bird discount: register by July 1 to save $75 and get a free pre-conference session (a $99 value). www.swfox.net
  • One basic question, one not so basic
    by Geoffrey Callaghan
    4 Replies
    Last post by Geoffrey Callaghan
      • I am attempting to write some functionality using the winsock control with VFP 6.0. I have a pretty good understanding of winsock itself, but I'm having trouble accessing the object from my code. So here are my two options, neither of which I can figure out right now: 1) The object is defined on a form, but needs to be accessed from code in a .prg. I have never been able to figure out how t
  • "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:
  • DBF with 503 fields
    by S.G.K.Hari
    9 Replies
    Last post by Bruno Yu - MSFT
      • Hello All. I have a DBF with 503 fields in my server . I could able to open in read only using dBase V. The dbf is updated thru an application. I want to query the file using VB or VFP. Thanks for all inadvance . Hari
  • How to keep VFP standard toolbar up all the time?
    by Lightening
    11 Replies
    Last post by dni
      • After I run my app. in the command window, the toolbar disappeared. I have to click View --> ToolBars --> Standard to pull it out. It is VFP 6. In VFP9, you may use: show window standard I am thinking of changing some default setting under the tools menu.
  • Forum Usage
    by Naomi Nosonovsky
    14 Replies
    Last post by AndyKr
      • Since this thread has gone off-topic, may I please ask few questions about this forum usage. 1) How can I see replies in the chronological order E.g. I only want to see the latest replies but I can not figure out how to do it. 2) Can I turn off Alerts for good I often forget to uncheck them when posting a message. 3) Why most of the messages appear in a very small unreadable f
  • Updating DBF from SQL server
    by tazvier
    6 Replies
    Last post by tazvier
      • Hi to everyone. I have the following issue; I need to update some information in DBF files but with a SP from SQL server. I have a linked server in my SQL server pointing to DBF directory. When I execute the following commands, I get everything ok: Select * from LinkedServer...mytable Insert into LinkedServer...mytable values('fiel1',¡¯field2','') But when I execute Update and
  • Activex in VFP
    by MPAZ
    7 Replies
    Last post by AndyKr
      • I am new programmer in VFP. I am using a VFP 6.0 I have a VB ActiveX, I insert this control in a form in VFP. It's OK.. but my problem is that one method of this control, recieve a parameter type VT_PRT.. And i don't know how means that and how this pass this parameters
  • Fax Report Using VFP9
    by emery
    11 Replies
    Last post by emery
      • As resolved in "VFP Fax Integration" thread , I have been using Jaime's method to fax Reports with graphic/image and it works very well for VFP6. set printer to name "Fax" report form myReport to file "myfile.tif" noconsole Recently I compiled and ran my program using VFP9, I got the following Program Error: OLE IDispatch exception code 0 f
  • REPORT FORM TO A WORD FILE
    by JLucio
    5 Replies
    Last post by Naomi Nosonovsky
      • Somebody knows how can I send an output of a REPORT FORM to a Word File. I mean a file .DOC. I have to preserve fonts, size, etc. It is to send documents by mail. Dont work only ASCII. Thanks in advance
  • odbc driver
    by vhockz
    3 Replies
    Last post by CetinBasoz
      • pls help me find the specific odbc driver for visual foxpro tables. tnks
  • Copy Data in spread sheet format
    by M_A_Baker
    3 Replies
    Last post by CetinBasoz
      • My question is that I have Visual Foxpro 6 installed in a machine which dont have Microsoft Excel and has some other spread sheet software (3rd party). when i write copy to ...type xl5, it generates error EXCEL.APPLICATION not found. and does not convert file into excel format. Can we transfer data using copy to ... type xl5 into a excel format so that it can be opened in 3rd party softw
  • Creating a folder using VFP6
    by mrfitness
    9 Replies
    Last post by Naomi Nosonovsky
      • I have a query within a loop that will be creating many files. It is based on a (variable) 'where clause'. What I wanted to do was to grab the first 3 characters of the (numeric) variable 'where clause', and create a folder named with that variable, and place the results of the query in that folder. I think I can get the program to work if I figure out how to tell VFP to create a folder named as p
  • 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
  • Why is qeury so slow?
    by Lightening
    10 Replies
    Last post by Lightening
      • I used this query statement. Code Snippet Sele a.*,b.address ; From NewCal a; Left Outer Join customer b On all( a.work_no)=b.wo_type+allt(str(b.wo_no)) Table A contains less than 1,000 records and table B contains about 30,000 records. In VFP6, it takes me a few seconds to get the results. In VFP9 + SP1, it takes me 4 min
  • CLOSE DATA
    by dni
    4 Replies
    Last post by dni
      • When I am usinsing CLOSE DATABASES in a button click method I receive the message box "File is not open". I have vfp 9 sp1, not vfp 7.
  • Thumbnail -Images
    by MM ROy
    10 Replies
    Last post by MM ROy
      • Sir, I am using Visual FoxPro 6.0 version. I want to view (like thumbnail) all the images of a folder (.jpg, .gif, etc.) using with visual foxpro form. The number of images may be varying. I have no idea....Please help... Roy MM
  • Copying a numeric value with decimals from a cursor into excel without rounding up
    by mrfitness
    14 Replies
    Last post by Naomi Nosonovsky
      • I am having trouble with copying numeric values with decimal places into excel. I have a select statement (some being sums of numeric fields with 2 decimal places) with a group by function and I place these results in cursor c1. When it tries to enter this value into excel, it rounds all values up. (eg 309.66 becomes 310) I tried changing the format of the excel file to numeric with 2 decimal plac
  • How to show properties window to a file in foxpro
    by surinder singh
    14 Replies
    Last post by surinder singh
      • Hi I want to show the properties window to the file selected by user on right click -> properties option. (as this is shown with any file when we right click on that file and click on properties option in widows explorer) If anybody knows about it , please tell me how to do this If any one knows to do this in Visual Foxpro then it will be good for me.