Search results for query: *

I'm trying to access VFP tables from a C# project, using a connection string that contains "Provider=VFPOLEDB.1;". It works on one machine, but on another machine the same code produces an error that "Provider is not registered on the local machine." How do I make sure that the provider is...

I am using C# to access Visual Fox Pro data. My connection string contains the clause "Provider=VFPOLEDB.1;" and a data source clause. The code works on one machine, but on another one I get the error message, "Provider is not registered on the local machine." How can I make sure that the...

I've been using subclassed controls with WinForms and sometimes, apparently randomly, after a Build, one of the controls on the form will be missing. It has happened with comboboxes, labels, and buttons. When I look at the code view, the control is still there, but it has been put to 0,0 with...

I'm making a check writer report and I need a function to convert numbers into verbal descriptions (e.g., 1210.25 into "One thousand two hundred ten and 25/100". Before I go to the trouble of writing one, I thought perhaps that someone had already done it. Does anyone have one? Thanks, Dick...

I have a VFP application that sent me email from my client's site when an error occurred, using Internet Explorer. Apparently, recent security patches have pulled the plug on this functionality, because it has quit working. I rewrote the function, using FTP to send the message to our FTP site...

When working in the VFP IDE with a "SET ESCAPE ON" in effect, I am able to interrupt a long SELECT SQL statement, but it doesn't work when running the compiled EXE version. Is there a way to interrupt the executeable?

I have tried to decipher the help file on the TRANSFORM function, but have failed to figure out how to do the simplest thing. I want to convert a number into a string with four digits using leading zeroes. There are no examples on how to use the format codes (e.g., @L). What is the format to...

I know that you can change the mouse pointer over certain objects by changing the MousePointer property of the object, but is there a way to change the general mouse pointer inside a program? I believe that I have seen something like: SET POINTER TO 11 && Change to an hourglass pointer but...

Can anyone tell me (or refer me to a source for) what the maximums are for the PDF format? Specifically, 1. How large can a PDF file be? 2. How many pages can be stored in a single PDF file? Does that depend on page content? My context is writing VFP reports into PDF files. I am storing...

I am trying to print a group of VFP reports, each to its own PDF file, but the resulting files are not recognized by the Acrobat reader. My code looks like this... SET PRINTER TO "Acrobat PDFWriter" *SET PRINTER TO "CutePDF Writer" && I've tried several *SET PRINTER TO "PDF995" USE MySource...

I need to take values from FoxPro tables, print them to certain X, Y locations on a bitmap of a tax form, and put the whole thing out to a PDF. Can this be done in FoxPro? I am replacing a VB program that does it using a Printer object. Regards, Dick

I'm getting a Nesting Error message in a situation where I'm trying to use EXIT to escape from a CASE statement. The EXIT command is shown at the bottom of the help page for DO CASE in VFP8, but the description of the EXIT command only talks about DO WHILE, FOR, and SCAN loops. My code looks...

I have a grid with an image control in the first column. I need to be able to make the image visible for some rows and not for others. Can it be done in VFP 8.0? -- Dick [cannon]

I have a spec that calls for a grid with a command button in one column. The color of the button needs to vary with certain conditions. I have tried making fields in the recordsource cursor that contain desired fore- and background colors and then setting the backcolor property for the button...

I need to create tables using VFP8.0 that can be used by FP2.6 equipped clients. My need is two-fold: 1. Using the "CREATE TABLE" command. 2. As the output of an SQL-SELECT statement. Does anyone know of a trick, magic keyword, registry hack, or ANY way to keep from having to go into 2.6 to...

Does anyone have a good method to export tables from Access 97 into a database container in VisualFoxPro 8 that will preserve long table and field names and field formats? I've got some tables with 140 fields that are a bit difficult to handle the export with manually. There are quite a few...

I've got a simple little login form that opens without having the focus (i.e., it is not selected). I don't remember having this trouble with other forms.... Here are some properties that I have set on the form: AutoCenter = .T. ShowWindow = 2 - As Top Level WindowState = 0 - Normal WindowType...

I've been using the following code for years to avoid the "File is in use" error when trying to open a table: IF USED('mytable') SELECT mytable ELSE SELECT 0 USE mytable ENDIF Recently, I have hit upon a problem where the table is open with an alias other than the table name...

I am trying to move right-justified numeric data in a grid left a couple of spaces to get some white space instead of having the numbers jammed up against the line of the column separator. The answer seemed obvious: put a format into the inputmask property of the column. I found that entering...

I'm trying to use a custom editor with VFP 8.0 and I can't get it to be recognized. Per the help file, I have added a "-C" with a configuration file name to the shortcut that initiates VFP 8.0. In the config file, I have specified the editor path and filename with a "TEDIT /N...