Search results for query: *

How do you step through each row of a MySQL table to perform an update. I want to start with the first row and then iterate through the table row by row and make possible field updates. I know how to update, I don't know how to step through each row, beginning to end. This used to be simple...

I am new to Python, coming from Foxpro and C#. I have 300,000 names in a MySQL table sorted alphabetically by last name then first name. I need to be able to find a name and then scroll up or down to view similar names. I am using Python and MySQL. In Foxpro, I would execute a SEEK command...

I've created an application (main.exe) using VFP9 and Installshield 5. When the app is installed on a users machine the user, as always, can choose an installation directory other than the default. Question: How do you set the application default directory at design time when the default...

Using VFP9, I have a table with 200,000 records. A recordtype field in the table is used to hold one of five values (A, B, C, D, E). Then, one of five pages in a pageframe is used to display each of the five recordtypes. For example, page 1 displays records of recordtype='A', page 2 displays...

I am using Installshield v5 (comes w/vfp9), have installed an application on a target machine (win98) and everything works fine. However, even though Installshield creates a shortcut on the desktop of the target machine that launches the applications properly, the properties dialog for that...

I have a pageframe with several pages. I have copied the objects from one page into a class. I then add the class to page two to recreate the objects from page 1 to page two. However, when the objects are saved as a class, they are placed in a container object that doesn't go away when it is...

I am adding objects to a page in a pageframe by using the following code in the Activate Method of the Page: This.AddObject('page2obj', 'page2obj') I added the class "page2obj" to the project. The class was created by highlighting some controls and then choosing "save as class..." from the...

When using the ActiveX control "Common Dialog Control version 6.0.", how does one disable the "Places Bar". By the way, this control is the "open file" dialog box. VFP8 Loomis

I have placed an ActiveX control on a form. The control is the "Common Dialog Control version 6.0." This control is the "open file" dialog box available in most every windows application know to man. My question: how do you get the filter property to work. If I set the filter property to...

I have a main form that calls a child form (Do form mychild1.scx)that in turn calls a child of its own (do form mychild2.scx. When I launch the main form and then child1, none of child1's properties appear in the debug windows and a subsequent launch of child2 results in child2 being unable to...

Recent forum responses have indicated that it is best to create variable and arrays as properties of a form rather than declarations in a main.prg program. However, when you do this, variables created in one form aren't available in another unless you use the long variable reference...

In previous forum responses, it has been suggested that arrays and variables should no longer be defined in main.prg but should instead be defined by the user as properties of a form. Problem is, when you need to use a variable in a form and that variable is defined in some other form, the...

It is simple to add properties to a form, at design time, using the VFP8 menu options. Similarly, can one add properties to a listbox at design time, and if so, how. I know how to accomplish this at run time using addproperty() method or function. Loomis

Now that Hentzenwerke Publishing no longer publishes FoxPro books and since attendance at foxpro conferences continues to dwindle, I again start to wonder whether my beloved FoxPro will soon be no more. Considering Foxpro's strengths, where would a VFP developer go as an alternative? What other...

I have been developing in foxpro for years. My applications involve large databases (100,000 to over 5,000,000 records). Data entry forms as well as printed reports are also a part of most my apps. Sophisticated queries are also required. Apps must be distributable. What development...

I am creating a user interface (dialog box) that will capture information, from the user, that will be the criteria for a query (select SQL statement). Two questions: since the query criteria are user definable, what is the best way to formulate SQL select statements whose clauses will vary...

It seems to me that in VFP6 there was a way to add objects to a form by dragging them from the form designer toolbar directly to the object list of the property window. There was also a way to delete objects from the Object List of the Property Window as well as move objects from one parent to...

If ones application is compliled into an .exe file, how do you get it to access commands in a config.fpw file. If a config file can't be used in conjuction with an .exe application, how do you issue a "screen=off" command so that the main visual foxpro screen won't flicker on startup...

What is the best design practice for sizing a form to a users particular screen resolution (640 X 480, etc). In other words, at run time, how do you make forms, and all objects contained therein, smaller when in 640 X 480 and bigger when in 1024 X 768. I know how to determine screen...

What is the best way to add a graph to a compiled and distributed application? The graph will depict data from a table or query cursor. The graph should appear on the screen (in a form) and must be printable.