Recent content by Loomis

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

Thank you for the thorough response.

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

MikeLewis & KeepingBusy: You guys are right, it really isn't broke so I should probably quite wasting my time trying to fix it. I admit I was a little curious about the problem and thought there might be a quick and simple fix. Thanks for your feedback. Loomis

Dear Keepingbusy: In looking at the responses, I am not sure if everyone understands my problem. I am using Installshield v5 (VFP9) and I understand how to create a shortcut on the target machine using Installshield. My problem is that even though the shortcut is created, and even though the...

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

Craig: Thank You, your syntax worked perfect. Now, do you know how to disable the "Places Bar" in the ActiveX "open" dialog box. Thanks, 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...

craigber: Thanks for the advise on formsets. I have a followup question regarding the availability of variables across forms. You advise to use "properties of a custom application class". Could you elaborate. Do you mean to create a class based on custom class, then base on object...

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