Search results for query: *

Is there any way of programatically determining if a table is part of a dbc file, and if so remove it (using the REMOVE TABLE command, presumably) Ideally, I'd like a program that will loop through all tables I have in a certain directory, determine if they're in the dbc and remove them from...

I've written a VFP7 app which has my own class in it. This class consists of controls and forms which are used extensively throughout the app. I now want to move the .vcx file to a different directory, so that I use it in multiple apps without having to make changes to multiple copies of the...

Let's say I have 2 tables, both of which are child tables of a master database. For my example (a hospital), one table holds all the medication required by a patient (patient details being in the master) [1 to many] and the second holds all procedures they've had [1 to many] Is it possible to...

Anyone out there know of a good (free) utility I can use to compare 2 projects. They were both the same yesterday, but I had to make some changes onsite. Then I lost my copy of the changes, and started doing them again back at my desk. Now I've got the copy back again (yeah, I know, I suck)...

I have an 8-column grid bound to a database. If the value of a particular field is empty, I want to hide the relevant column (so field1 is empty, hide column1) I tried: WITH thisform.grid.columnx .width=0 .movable=.F. .resizable=.F. ENDWITH but it still puts a line in for the...

If I build an exe and then create a setup for it, etc, what sort of requirements am I looking at? RAM, Hard disk space (aprt from my exe and date, obviously), pre-installed options, working OSs, etc Just want to put up a little blurb that should be the minimum required spec.

I've created a new class based on a form, and added, amongst other things, some properties. One of these properties is .ShowHelp, which is either .T. or .F., .F. by default. When I use the class, I know that it can be either .T. or .F. but I'd like to give the other programmers a chance by...

I have a checkbox and I want the caption to appear enabled when the box is disabled. Yeah, it's crap, but we have all labels enabled at all times, so a disabled checkbox caption looks bad beside it. According to a thread here and some stuff at Wike, setting ForeColor to 0,0,1 and...

I have an error form which is called ON ERROR, displaying the relevant error and writing to a text file, etc. Now, in case the error is a major one that stops the user from continuing on (eg., it may be an error in the GotFocus() event of the first control on the form, meaning an infinite loop...

I'm a little unclear about how graphic files are handled by VFP7. I have a number of bitmaps I want to stick on the toolbar of my app. I've put these into a gfx directory hanging off the main project directory. So when I add the picture, it's d:\My Projects\VFP7\Customer\Gfx\name.bmp. If I...

I have a database consiting of customer details, and I have to write a report that will return all customers who have a birthday between 2 dates. The database holds the dob, so what I did was I brought the dob up to the year of the dates and then just did a BETWEEN() clause. All well and good...

Anyone know how to get a textbox containing a date to first highlight the first 2 characters, when tab is pressed, highlight the 4th and 5th, when tab is pressed once more, highlight the 7th and 8th and when tab is pressed once more come out of the box. Much like the time control in Windows'...

I have a textbox on my form bound to a db field, N4. However, when I go into the box, I can type *any* amount into it, and having left, it gets turned into extended numbers (1e+14) or worse, *****'s. I always assumed that if a textbox is bound to a field of a certain length, that's how long...

I have a project sitting in c:\vfp (say) and when I build it, I always want the resulting app to go onto our network (m:\projects\it\visual foxpro\accoutancy\v6\Nov\project.app) When I go to build the app, obviously, it brings up the current 'home' directory of the project, and I have to...

Using FP2.6, I always used to BROWSE FOR BETWEEN(T_DATE1, {8/3/2001}, {12/12/2002}) to find records between 2 dates. Now of course, when I use {8/3/2001} I get the old "Ambiguous date/datetime constant..." message. I really don't want to have to type in {^2001-03-08} every time I...

I've created a date-combo class as per the instructions in Hetzenwerke's 1001 Things You Wanted to Know About VFP (if you don't have the book, it's pretty basic, a text box, a command button, a calendar control. You can type into the text box, or click the command button to bring up the...

2 distinct problems, but I figured I'd save myself some typing... 1. I created a menu with the menu builder, then copied the generated code to the Init procedure of my form. It works fine in design, but when I click on any option after building, it falls over, unable to find the form I'm...

I've created a menu using the menu builder and brought the mpr code into my form. In the middle of messing around with it, I decided to add shortcut keys to some of the more used options within those menus. It works fine but I'd like to get the shortcut key displayed beside the menu option if...

After some brief experimentation with DD's ActiveBar we've decided to go old-skool and use Foxpro's Menu builder to build our menus. AB was overkill, anyway. So, I've been recreating all the menus that were in ActiveBar over to VFP's menu builder, but I've found a little problem. We have a...

We are using the OLE calendar control in quite a number of places on our system. It's causing no problems here, but a user has reported that in some forms, they cannot get the calendar "to go away". I have the calendar on a form which is being called modally. When I double click on...