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