Search results for query: *

William, Most welcome. And I know where you are coming from "Can't see the forest - all these )(*&()*&%*$ trees are getting in the way!

The debugger works on forms and programs, etc. Open up the project, place breakpoints in the the code/form methods, etc. where you want to investigate things and then run the Main.Prg. When execution reaches a breakpoint, your debugger will appear. If it doesn't select Tools->Debugger in the...

William, Try deleting your FoxUser table. VFP will re-create them automatically. The FoxUser table is where VFP stores your preferences.

Sorry about that - forgot to use UPPER(cSurname) in the where condition - couldn't figure out how to edit the post once I found the error.

Just to add to what everybody else has given you, the forms that the wizard creates are not all that user friendly. Lets assume that you create that wizard based form over a table that has 1,000,000 records and your user wants to get to a record located somewhere near the middle. That user...

Saving a screen print (using snagit or something like that) is of some value, Logging the event properly makes more sense. What is the error? What method or event triggered the error? What tables are open at the time? What are the record pointers for these tables (what is the RECNO() or...

William, Let me see if I have you - you have a table called Temp2 and the user can "decide" to use temp2 !!?? How can the user make this decision? In a typical app, a user may have a temporary table (for example a data input batch might be stored in a temporary table when the user needs to...

Ash, It does rather sound as if you need to use Remote Desktop/Terminal Services (Or any of a number of other similar utilities - PC Anywhere, etc.) The first thing you will need is an account with permissions that allow you to access the customer's machine via T/S and you will need...

Not really sure what you are asking but try this: Create a report and set your page footer up so it uses up most of the page. You don't have to put anything in there. Now run the report and you will see a whole bunch of blank space used up for the page footer. In other words, your detail...

Bart, Like Mike, I too have a cut/copy/paste/undo/redo section in my main menu, so I don't have to do the same thing in the rightclick menu. I reserve rightclick menus for items specific to that particular control. For example, Reset to Default, Clear, Help, etc. If you leave cut/copy/paste...

If you are using tables in your D/E, this may be the problem. Normally, the relative path "AppDir\Data" remains constant. For example, \\Server\Production\AppDir\Data VS \\Server\Development\AppDir\Data But in this case you are changing the relative path...

Q, After looking at that code, I would most definately want to rewrite it. At first blush, I think you could turn all of this into a single select statement. Much easier to maintain in the future - and NOW is always a good time to make code better. Ken

I think you missed Dave Summers reply. Your problem in this index statement is that you are concatenating numbers and characters - you cannot do this. Change the numbers into characters using the str() function (just as you did for postalzone, copies and orderby. INDEX ON IIF(Copies > 1...

If I have a complex report to do, I simplify it using a SELECT statement. For example, if you have a series of tables to use (all related to eachother) and you need to set an index that goes across these tables, it becomes somewhat complex. Get the complexities out of the way using SELECT...

something like LIKE()?? Ken

You can isometrically stretch an image up or down (as Scott suggests) but if you are talking about modifying the actual size of the image file, you cannot do this with native VFP. I deal with a lot of image files and I NEVER use a general field. Too much OLE corruption. If you have to store...

There is one proviso though - if you have over 1024 image files in a single directory, you may find that windows indexing no longer works for that dir - it will slow down considerably. The solution to this is to create a directory structure rather than a single directory. You could do...

I cannot remember if you have it in VFP 6, but take a look at FIELD() in help. It returns the name of a field 1, field 2, etc. You could use this to create a REPLACE statement that you could run using macro substitution. For example, FOR i = 1 TO FCOUNT([MyTable]) IF NOT...

Just a SWAG, but if you are running this as a service, have you granted permissions to open the tables? Ken

Why create and then delete tags? If you need an index, you need it. Create it and leave it there. Now you never have to create it again. Deleting a tag takes forever, so why do it. I typically create an index on every field in the table plus an index on deleted(). VFP will optimize just...