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

Ramani, as always you're the man. I was kinda hoping to avoid the VFP "locate" thing, though, and just change the paths myself. That way, I don't have to go into each and every form, click "Locate", find the new directory, save, etc. Isn't there a better way? (And yes...

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

Thanks, ramani, great code. Saved me a whole evening of hassle. Just in case others stumble across this code, a couple of things: The "order by" in union Selects has to be field numbers, rather than names The resulting fields of the 2 SQL statements have to be identical, so if you...

Thanks, Rick, you're a God ;-)

chrisman, not sure how useful the result dbf would be. If a patient has 20 medications, and 1 procedure, I'll get 20 recordsl Med1 Proc1 Med2 Proc1 Med3 Proc1, etc Doesn't really help me in my report.

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

ramani, great plan, but onsite, I built the exe, and rebuilt all files, so they all have the same date. Rick, your idea looks like a winner, but I've never used SCCTEXT before - I downloaded it, but how do I run it (I assume it required parameters or something?)

Don, yep, that's the problem. Assuming I lost it, I made what changes I could remember from onsite then continued developing it. Now that I have the onsite copy, I'd like to make sure that I have everything (I'm not unduly worried - the bugs I fixed were great big honking ones that I'd never...

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

chpicker, originally I had it that the unused columns were moved to the left hand side of the grid, and all used columns were expanded to fill the gap. That was what I was using a table for the recordsource, and was able to match columns to specific fields. Unfortunately, I've had to change it...

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

Rick, points well taken, but I just want to get a rough idea, at least so that users of 'lesser' machines won't download the software and then bug me that it doesn't work on their 386 with Win 3.1! I've always assumed that "mimimum spec" meant your machine in it's "virgin&quot...

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.

Chris, I'm happy with what I have, but you know how it is with development. Something works fine on your computer when you're using it properly. Give it to a customer and they manage to break it within seconds. I can't find anything wrong with the checkbox as it is, but I'm concerned that you...

ramani, the question may not have been clear. The property is a new property, not an existing property of one of the child controls. From what Rick is saying, it seems pretty clear that I can't actually give the developer options for my new property (this can be .T. or .F.) and the best I can...

I should know what PEMs are, but I don't. Little help? So far, all I did was pretty much as the instructions, apart from the shape over the entire checkbox, and the conditional click on that shape Basically, the control gets focus, I show the 'focus rectangle', it loses focus, I hide it...

Thanks ramani. Unfortunately, I've inherited this project and it has this bunch of classes pre-defined that work a certain way with the objects on the form. Throwing a brand new form property into the mix might just cause it to explode ;-)

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

Thanks Chris. I'm not sure why I need to show the "focus" shape when my mouse passes over it - normal checkboxes don't behave like that! Maybe in XP, huh?