Search results for query: *

I will be retiring on September 8th. I just wanted to say Thank you, especially to Mike and Olaf for all the great help you have given to me over the years! You guys really know Visual Foxpro!!!

I have a request to write a program that will get a file, encrypt it, and then ftp it to a user. The first and last are easy, but I have never tried encrypting anything in foxprow 9.0. I have tried to read up on it but I do not understand 1/2 of what I am reading and have found no examples...

I need to find a way to catch the error #1705 in a process that is used extensively by my company. If it is caught, I want it to try the process again, 1 more time. The process is after a file has completed its processing, it is moved to a 'done' folder or if there was an error, moved to an...

We have a crystal report form that is printed from time to time and called from VFP. When it was created, it used an XML created (Call it 'ABC.xml'). Now they want to change the name of the xml on each form printed... (Call it ABC123.xml) The actual xml has not changed, just the name. In...

I have used Crystal Reports with Visual Studio and Foxpro for several years without a problem. All at once, I have one program that will no longer display the form in the viewer. The form uses an XML document for data and creates a graph and reports on other data. It will print the form from...

I am attempting to create a fairly difficult report in Crystal Reports (2008) It contains a Report Header, a Page Header, and 2 footers. The second footer is in fact a full page instruction sheet for the form. It cannot contain the Page Header. How can I turn it off?

We have a fax program running on 2 computers simultaneously that uses a folder (we will say f:\FaxFiles\) to hold the .pdf and .fmf files used. We have a 'house keeping' program that constantly scans this file folder for files older than 14 days. This has worked for years. Now all at once, we...

Every night we are downloading a .csv file from an FTP site. I then need to copy the data into a cursor. Here is what I did... CREATE CURSOR WITCURSOR (WIT_NO C(8), ACTIVE C(1), SETUPCUDTE C(19), EXPIREDTE C(19), ; LAST1 C(30), FIRST1 C(30), N1_MIDDLE C(1), LAST2 C(30), FIRST2 C(30)...

We have a process that works like a 'Traffic Cop' processing thousands of files daily. It works when a user copies a .txt file to a specific file folder, the process will see it, open it, process it, then it copies it to a 'done' folder and deletes the original file. (A "Move") Recently, we...

I am in the process of rewriting an old foxbase program to vb.net. In the old process, they used numerous '.mem' files. I need to see what is in these files but can find no way to open them. Can you help me out?

Hi Guys... I am working on a project, converting a foxpro program to VB.NET. I have conquered all except the data sort on 2 reports. The foxpro script looks like this CASE mSORT=1 INDEX ON DEPT + STR(MSORTN,3) + MSORTA + MODEL FOR QTY > 0 TO DLDSOP CASE mSORT=2 INDEX ON DEPT...

I am trying to use the "Copy File" command to copy a file from one location (f:\Orig\myfile) to another that does not yet exist. (f:\Dest\folder2\folder3\myfile). In my example, the destination exists to f:\Dest but the two folders may have to be created. (Hopefully by the program on the fly)...

We have a legacy program built with Foxpro for Windows 2.6 that is still in use and not giving us any problems... until now. It uses data from a dbf file that we have recently changed to use foxpro 9.0 to create. The Foxpro 9 creates the dbf which is called zipcode_dnld.dbf and once created...

Hello Friends, I am trying to insert data into a sql server table. One of the pieced of data (lcprocdate) is in fact a date field in the sql table but a string in foxpro. ("10/19/2013"). I have tried to pass it as a sting, as a date field (ctod). I have tried to send it using the...

Probably a simple process, but I am a simple ... I am needing to add text to the bottom left of the displayed form. My problem is that I have a procedure that will take 45 seconds to 3 minutes to process and I need to have something happening to keep the user from stopping the process before...

We have a program that works as a 'traffic cop' for processing, distributing, emailing, etc. different files and processes. Many use reports that are created in Crystal Reports. At the time of its conception, we used Crystal Reports v8, then v8.5, then version 9. We now are using newer...

We have postscript files that are produced in a Foxpro process with Crystal Reports. These files are and will always be duplex-no tumble when printed at the printer, however, with no changes we can find being made on any systems, hardware or files they are no longer created duplex. We have...

I have a piece of software I have written previously that accesses a VFP database. Now when I try to run it it gives me the following error message... The 'VFPOLEDB.1' provider is not registered on the local machine. I am using Visual Studio 2008 to create the program on a Windows 7 machine...

In .Net (which I am most familiar) I would simply say nVariable = nDataSet.Tables("Table").rows.count then ask if the nVariable is greater than 1. I am not seeing how it is done in Foxprow9. (Hot project or I would hunt til I found this)

I am hitting my usual hurdle, working with dates. I have data which is downloaded from a SQL Database into a cursor. One of the fields contains a date field. ex. [24-May-12 08:42:33] I need send it out to another process as (mmddyyyy hh.mm.ss). ex. [05242012 08.42.33] Should be a piece...