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...
I know where you are both coming from and I agree that this would allow the Crystal report to be created. What you suggest gets murkier when you learn that this one process is used on at least 150 different reports. All created with different xml files. The xml filename and report name are...
Yes that will (and does) work. It is the users request to be able to name them differently for where they actually get the data. I have recommended that they put a memo field in their file with that information and they can search for that. I unfortunately told them "We do that all the time...
Good Morning Mike,
Change the name back... yes I did. Worked fine. I also recreated the form using ABC123 then tried to use ABC. Same problem. Over night I got a response back from SAP stating that since VFP is out of production etc. they no longer support it.
Good Morning Olaf...
I just finished testing Versions of Crystal in .net and as I stated earlier, it worked without error in .net on both. W:\ABC.xml was the name used when the form was created. 'SetDataSource' is supposed to change the from W:\ABC.xml to a new name (W:\ABC123.xml). The...
Hi Mike,
The versions have progressed without change (us starting at 8.0) as far as .net. As I said before, we are now at 2013. VFP however cannot use any version over 9 due to how it creates and uses the files. (above my pay grade) The VS.net however will work with a CrystalReport9 file...
Yes we have purchased several versions of Crystal Reports. We are forced to use CrystalReports 9 with VFP as later versions are not compatible. We are using CrystalReports2013 with VS.net. Both are OLE. CustStudyRptDS1 is a Dataset that is created with code from numerous data tables. It was...
Olaf... To further define etc.
Please understand that the code in the VFP is not the only one I have tried... Just the last one. I have tried many variations of both yours and Mikes suggestions. i.e. the STRCONV conversion setting is not likely '6' but that is the last one tried before the...
Good Morning Olaf,
I tried the Unicode without success too. Here is the code from VFP and then DotNet. Some differences in the code i.e. the VFP changes the orientation and passes a value for ReportTitle etc.
VFP
loCrystal=CreateObject("CrystalRuntime.Application")...
When the Crystal Report was created, an xml file (W:\ABC.xml) was used as data. I pointed at it in Crystal Reports as ADO.net(XML). Now when I call for that report to be used, I am trying to pass the new xml (W:\ABC123.xml). Both XML's have the exact same structure, just the data changes...
Thanks Mike...
I tried those (and many variations of your suggestions to no avail. Adding .Database did allow the code to continue without error until it tried to print the Crystal Report, at which time it again wanted the xml name (In our example ABC.xml) used when creating the form.
Olaf,
The W:\ refers to a drive which has been created for use with this program only. It is mapped on this network as a drive. As for trying it, I tryed many ways to do this. (As I said I feel better because what the experts are suggesting is what I have tried (so far)) I did not include...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.