Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PatMcLaughlin

    Thanks for the help...

    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!!!
  2. PatMcLaughlin

    Encrypting Files

    This will be a new program, and I can dictate the form of encryption/key. The files will go to a small number (under 10) users.
  3. PatMcLaughlin

    Encrypting Files

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

    Catching and Handling File Access Denied error in a Try-Catch-EndTry

    Between Mike and Tamar I have a process that appears to be working as I envisioned. Thanks for the quick posts!
  5. PatMcLaughlin

    Catching and Handling File Access Denied error in a Try-Catch-EndTry

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

    setDataSource in Crystal Report form via code

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

    setDataSource in Crystal Report form via code

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

    setDataSource in Crystal Report form via code

    Sorry Olaf... Just a typo, the code has the '\'
  9. PatMcLaughlin

    setDataSource in Crystal Report form via code

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

    setDataSource in Crystal Report form via code

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

    setDataSource in Crystal Report form via code

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

    setDataSource in Crystal Report form via code

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

    setDataSource in Crystal Report form via code

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

    setDataSource in Crystal Report form via code

    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")...
  15. PatMcLaughlin

    setDataSource in Crystal Report form via code

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

    setDataSource in Crystal Report form via code

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

    setDataSource in Crystal Report form via code

    You are correct Dan and the \ was used in the code.
  18. PatMcLaughlin

    setDataSource in Crystal Report form via code

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

    setDataSource in Crystal Report form via code

    Try again... I meant to hit preview Hi Mike, It gives me 'OLE error code 0x80020006:Unknown name' Pat
  20. PatMcLaughlin

    setDataSource in Crystal Report form via code

    Hi Mike, It gives me 'OLE error code 0x80020006:Unknown name'

Part and Inventory Search

Back
Top