Answer Questions

• Krishan Ariyawansa Using VTable interface of Excel Component from FoxPro 8.0

  I am writing a FoxPro program that uses the Microsoft Excel component in order to generate a XLS file. However, FoxPro is evidently using the IDispatch form of the Excel interfaces instead of the VTable interface. How do I write the program so that FoxPro will use the VTable interface instead Your welcome. 70000 rows is not too much, strange you needed it. Check CreateObjectEx() and sys(2333). My curios ...Show All

• Dustyn Lightfoot VFP8 on Win98

  Dear Experts It is possible to run VFP8 on Win98. If yes then How to install How to create EXE files How to distribute Exe files Please Help VFP8 runtimes will run on Windows 98. It is not recommended for the IDE for developing though. See: http://fox.wikis.com/wc.dll Wiki~VFP8Released >How to create EXE files Create a project. Add your main prg or form and build an APP to test first. When you build the project or an APp it shoul ...Show All

• duncan.mcleod DELETE FOR-PACK ON BUFFERED TABLES

  I have a buffered(5-optimistic )tables in vfp 9.0.when i use delete the records arent deleted i use tableupdate but they dont get deleted.i use pack but i get a msg saying table should be in no buffered mode i then change buff to 0 (not programmatically with cursorset.. but from dataenviroment) but is still get the msg! how can i delete a record table must be in buffered mode i have a grid,and i want when a us ...Show All

• H. Gøttig Select SQL Problem

  I am trying to select records from a database to determine qualifying order over 3 rounds of competition.  I *thought* I had it working but the results are not always correct. I need to find the lowest number in the field IQUARTER from a list of runs from many different entries listed by the field RACESESSIONS, but I need only the lowest for each contestant.  If there is a tie then the highest Miles Per Hour from the field ...Show All

• Stanislav D 12 hour time format

  Hello, I am doing a program that will compute the time in and time out.  As much as possible I want to do the time() function and not the datetime() function but the problem is if I use time() it displays the 24 hour format.  What I am tasked to do is to subtruct the time out to time in and be able to display the 12 hour format. Any advice will be greatly appreciated. Thanks for the response. I have a follow up question ho ...Show All

• Jon Haakon My form runs great inside of VFP, but has errors running from the exe...

  I have a form that uses a combo box for the user to select from. Their selection then is used as a basis for searching a table via a SELECT statement. The results of the SELECT statement are then written to a different table, where they are available for export as an xls file. It is searching an automotive customer info list by car make... This works flawlessly within VFP, but from the compiled exe I get complaints that Object 'wholesale_form ...Show All

• Kmaure External Connect

  Hi I know in Access you can run SELECT queries on external database. You just have to specify type and path. For example: SELECT * FROM <tablename> IN '' [ type ; DATABASE=<path>;] For dBase data source there are values: dBase III, dBase IV;  for Excel - Excel 5.0, Excel 8.0. What should I write to specify FoxPro type It will depend entirely on the version of VF ...Show All

• Adarsh Sridhar GRID REFRESH

  Im having problems refreshing a grid.i have placed a table in data enviroment.then i drag and dropped all of his items creating a grid.then in a button i have a select...where..into this table.this way i put new values in the table,basically i overwrite the entire table.at that time grid becomes white,no values i tried grid.refresh nothing i tried to grid.recordsource="" select where into... grin.recordsource=mytable  still nothing is there ...Show All

• bilbo08831 line/column numbers are not displayed

  In the status bar of my source code editor there are no column or line numbers. I go to Edit-->Properties and the checkbox "show line/column position" is properly checked. The help says that the numbers aren't displayed if wordwrap enabled. It is unaccessible in my editor properties dialog box. I cannot enable it because it dimmed. What else is missing here Thanks. Yoe are 100% correct. It needs SET MESSAGE TO every time you start ...Show All

• Roberto Costelli Search Form

  I'm using the QBF solution form that is with VFP 9.0. How can I make it so that the search doesn't need to be case sensitive If I want to search for David, I want my users to be able to type in david & still find that record. You could do that. Basically in your example you could UPPER() the search string in your cCondition variable, or in whatever the ParseCondition()  method returns. ...Show All

• Martinezg sending email from VFP through MS Outlook

  We have the following code for sending email to Outlook. The email gets sent, but the font size is always 36 px or 36 pt (we tried both). None of the <cr><lf> show up. The email is one big paragraph. Can anyone help   Here is the code: LOCAL loApp, loEmailItem, cHex  lnsize = '"' + str(gaPointsize(Slcrm.nbodysize),2,0)+ '"'  cHex = ''  nDec = Slcrm.nColor    nPower = 8  DO WHILE nPower > 0 & ...Show All

• LISABET Which one is faster, cursors, queries, local views, other?

  Hello, I'm using VFP 7 on a very old machine. I'm working with very large tables and I need to create a lot of queries, but my tables are so large it takes forever to load the results. I've been creating cursors on the run from SELECT statements but it's still very slow.... What can I do to optimize my queries/views so they are much faster... I'm new to this, so I don't know much... I just need to be able to run all this queries ...Show All

• Rajesh Prabhu. R Grid Resizing

  Hello All, I have a query to do with resizing forms and grids in VFP. I have a grid on a form with 8 columns. In the resize event of the form I have put code to resize the grid at the same time so it matches the Width and Height of the form. However, I have come across a problem with resizing the columns within the grid. Ideally, I would like to adjust each columns width as the grid is being resized. (I.E. Columns will grow when the grid is m ...Show All

• Bistesh Grid headers default mouse pointers etc...

  Hi all; I am creating grids in my forms by dropping a table into the form. The default header's mouse icon is a down arrow which misleads the user into thinking that the column can be sorted. Is there a way to change this default so it doesn't have the down arrow Thx. Change the Grid.column.header.MousePointer Property to 1 thisform .grdMyGrid.column1.header1. MousePointer = 1 Da ...Show All

• John Neighbors Downloading and uploading file from URL

  Hi. First task : How to download a file from internert via FoxPro Second task : How to upload a file in Foxpro via ftp Thanks Hi. Nice, but still not what I was looking for. I want to get list of files from a directory on FTP for example in listbox. Then I will choose one of them to download. Download will look like a "copy to" not like explorer download. Like copying file from one plac ...Show All