Only Title

Answer Questions

• ymac Suggest a Control...

  Hi, I'm in need of using calculator extensively in my application. Built on VFP 6.0. I tried with the following code Activate window calculator . . . THen I Tried Activate window calculator noshow Show window calculator in window <wname> . . . But the calculator doesn't pop-up..... But If i close the application, I find the calcultor active in Foxpro Desktop... I guessed the reason as I ha ...Show All

• WernerVN "feature is not available" - complete diagnostic

  I finally had time to focus on this thing alone and get the error reporting straight. I do have now memo fields with errStamps pertaining to every breakdown. One example: FUNCTION addPropToForm (oForm) oForm.AddProperty ("dBaseWe","",1) oForm.AddProperty ("dirWe","",1) oForm.AddProperty ("comboWe","",1) oForm.AddProperty ("tabWe","",1) ...... ...Show All

• jhowa1 MSGraph.Chart.8 control

  I need to make charts. I started with MSChart Control and so far I've accomplished almost all I wanted except for one thing which totally eludes me. I need a simple line chart, not columns or a pie. I need to display a row of data like DJIA or similar indices with no additional vertical bars or other embelishments. The curve comes out nice but a lot of space on the chart is wasted because the curve is being plotted too high on the chart in ve ...Show All

• sn1022 How random is the RAND() function?

  Hi, Is the RAND() function in FoxPro based on a well-known algorithm - i.e. is it certified or have anybody performed a diehard test ( http://en.wikipedia.org/wiki/Diehard_tests ) Thanks in advance for any replies, /Michael I don't know what algorithm they're using, but I have done some tests on it and found it's pretty good. I published code for Chi-squared and Coupon Collector's tests in HackFox. Tamar ...Show All

• ethom209 Fatal Error when writing to excel

  Hi, The version of Foxpro is 6.0.  The application I am buliding is to write data into Excel 2003.  There are times when I am getting a Fatal Error at a stage when I am writing the data into the cells.  Prior to this step I have other processes where I add more sheets and rename them, setup the borders and page setup and all works fine. I try to debug the application and it runs fine.  The problem is that the message is ...Show All

• sharon n. use the reccount

  hello all  I use "set filter to" and want to know how much record is match the filter condition. I use the "reccount()"  but it return the result is not I want. it is all the record count Interesting! Additional questions: You mean we should use SELECT ALL .. FROM.. WHERE <filter condision> . How do I address the resulting set Does it have the same alias name as ...Show All

• hoffi executable database

  I have constructed a project in VFP 9.0.   I want to make the project an executable database so that others that don’t have VFP installed on their machine can access the forms that display the information.   How do I do this   Also I’ll need to update the table periodically so does this mean I put the table on the server   I’m really lost in all of this.   InstallShield Express Li ...Show All

• Riki0410 table buffering mode

  On a statement like this: IF NOT initTableEmpty TABLEUPDATE () ENDIF I get an error: This operation requires table to be opened in buffering mode . SQLBUFFERING is set to ON before the table is opened. It does not help. Actually the error happens once in a while for no reason. I cannot understand what triggers it. Most of the time the statement works. The USE command does seem to have no option for buffering either. Is any h ...Show All

• caprock Strategy for multiple index query

  Hi all; I am using a sql query and I am sending the results to a grid (I mean I set the recordsource to the resulting cursor). I need to have the grid 'sortable' by several columns. The user will click a header and the grid will be sorted by that column. I am wondering what is the proper way of doing this: Am I to run a query to a cursor, and then do a several 'index on' commands, or is there a better way thanks, Aleniko ...Show All

• Rony Problem with SUM() function?

  I have a table with colums for debit and credit, each column has 2 decimals. I enter in the command window: sum(debit) to x and sum(credit) to y, then x=y. Result: they are not equal. I ask output: x and y, they are equal. Then I type: SET DECIMALS TO 10 and do the same things. Now the output shows me that x is not the same as y. There are differences in the 5th decimal position of x and y. How is this possible My table has only 2 decimals! I ...Show All

• BrianZim Main Window Default Size/Location

  I would like to know what determines where the compiled EXE application window opens and what size it is. I would like to have the window: - remember if it was maximized or - remember last size and position Right now it is always starting in the top/left corner and I'm not sure what I did to get it that way. Thanks >You can change the main form to AUTOCENTER = .T. if you want it to always be centered.  ...Show All

• bwagner Auto-shutdown

  I manage a program that I often enhance or revise. When it comes time to recompile I have to track down the users and ask them to close the program. There is one in particular who starts the program first thing in the AM and leaves it up all day. I want to put in a feature that will detect XX minutes of inactivity and close the program. I tried 'IF Inkey(300) = 0' but that just stops and waits 5 minutes. I think the key is the timer control but ...Show All

• Sriram Subramanian - MSFT FoxPro v9 vs Visual dBASE Plus 2.01 BDE 5.2.02

  Hi there. I just installed a Visual FoxPro 9.0 and started "playing" with it. Tried to create a table - it is straightforward and then a form. It seems to be a rich platform. Something puzzles me though. I do have extensive experience with Visual dBASE PLUS and previous versions in terms of OO language and form/table designer. Thus I am trying to compare. I am attempting to migrate to MS software/platforms wholesale since the dBASE is offering l ...Show All

• BloomyMB Drew Speedie Dies in Accident

  The following is a re-post fromt he FoxPro Wiki about the accident that killed one of our long-standing Visual FoxPro Forum contributors and a personal friend of mine, Drew Speedie and his son, Brent, last Friday: On Friday, September 16, 2005, Drew Speedie and his son, Brent, fell a few hundred feet to their deaths from a bridge in Yellowstone Park. The Speedie family was on vacation there. Details of this tragedy are extremely limited at this ...Show All

• Alex Chertov Novice converting from VFP 5 to client/server using Microsoft SQL - HELP PLEASE!!!

  I currently have an application that is written in VFP 5.0 and running on Windows XP machines with the database stored on a Windows 2000 server. It was first installed in 2000 and has had modules added, the most recent being 4 months ago. However, I have been having some problems with the program seeing that the database sizes has grown considerably with at least 2 tables having over 20000 records. The hardware technician has indicated that ...Show All