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!

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

Recent content by rlawrence

  1. rlawrence

    Access VFP Tables on Linux?

    Thanks guys, New leads to follow up. I'll try to report back if I find something that actually works.
  2. rlawrence

    Access VFP Tables on Linux?

    Thanks Mike, Actually, I have attempted to install Progress DataDirect. I may have to go back to it, but the installation didn't go well. I'm wondering whether I'm having issues because of Debian. I'll work that out with them, but the process has not been smooth. I feel like they have also...
  3. rlawrence

    Access VFP Tables on Linux?

    Hi folks, It's been a while, but this seems like the best place to get a fresh answer to an old question: How can I access my VFP data on a Linux server? My Linux server is running Debian 9, Apache 2, PHP 7, MariaDB, and ODBC. I have a legacy Foxpro 7 application that I am trying to migrate...
  4. rlawrence

    VFP 7 and Windows 7/8 compatibility issues...

    Thanks Olaf. I hate to upset something that has been working for some time, but I'll take a good look at it. Thanks again to all. You've given me some new things to think about and helped bolster my confidence about what should work. I'll post here again if anything new comes up. Best...
  5. rlawrence

    VFP 7 and Windows 7/8 compatibility issues...

    Ummm... actually, it's been working pretty well for many years. Also, the temp folder IS on the local drive. However, I thought you might have something here, so I set it to a physical path on my Windows 7 machine yesterday, removed the compatibility mode setting, and viola! The same report...
  6. rlawrence

    VFP 7 and Windows 7/8 compatibility issues...

    Aaah! Definitely worth looking at. I'll poke that that when I get on my Win 7 machine. My understanding, however, is that TMPFILES="Temp" should use the "Temp" sub-folder in my current directory--which is how the application is configured. A "Temp" folder is created as part of the...
  7. rlawrence

    VFP 7 and Windows 7/8 compatibility issues...

    Assuming there is a difference, I'll have to try to capture the query on my Windows 7 machine. Not a trivial task. I'll try to do that later today. But again, the query runs fine in compatibility mode on the same machine and database.
  8. rlawrence

    VFP 7 and Windows 7/8 compatibility issues...

    Actually, it's a bit more complicated than that. I've implemented a multi-tiered query capability. The line you cite is part of that system. Here is the code as it appears just before execution by EXESCRIPT(). (Sorry, I mis-named the execution function earlier.) Also, sorry for the loss of...
  9. rlawrence

    VFP 7 and Windows 7/8 compatibility issues...

    Almost missed this... I'll check it out. Thanks Rob. And this from Dave... Obviously, the answer here is, "Yes". All path substitutions use the DBF() function, so they should be physical paths. But, perhaps there is a difference when running in compatibility mode? I'll check that out...
  10. rlawrence

    VFP 7 and Windows 7/8 compatibility issues...

    Also an intriguing point from Rob. Yes, complex SQL queries exacerbate the problem. Olaf, you asked me to provide the query that was causing a specific problem. I haven't yet captured it at the point of execution, but here is my template. This query is used in a "Monthly Sales by Title"...
  11. rlawrence

    VFP 7 and Windows 7/8 compatibility issues...

    Very interesting discussion. I have two users who are having issues--both running Windows 7 on their client machines. One keeps their data on a Windows Small Business Server (Win 2008?), the other is running a peer-to-peer network. A quote from Dan: I have to admit that I don't really...
  12. rlawrence

    VFP 7 and Windows 7/8 compatibility issues...

    No Olaf, I've never been to the Middle East. [pharaoh] I do have relatives in Germany though. Actually, I have the ability to log the SQL Query. I really don't believe the query itself is the issue since it works everywhere else. Dave, You ask some interesting questions. I am pretty well...
  13. rlawrence

    VFP 7 and Windows 7/8 compatibility issues...

    One option I haven't had a chance to investigate thoroughly myself is the use of a virtual machine. I know that has been mentioned in other threads on this forum. I made the suggestion to one of my users. Here's the response I just received: Well, there's one out. Would still like to better...
  14. rlawrence

    VFP 7 and Windows 7/8 compatibility issues...

    Hi Olaf, I have to meet you some day. You have responded to so many of my posts, I feel like we are old friends. I totally agree with your assessment of the "Syntax Error". In this case, however, I run exactly the same report with exactly the same selection criteria. The SQL command is...
  15. rlawrence

    VFP 7 and Windows 7/8 compatibility issues...

    Here's more information in response to some questions. ______________________________ Hi Dave, Thanks for your comments. Actually, I don't have a lot of specifics, because I can't reproduce the problems. It may be helpful to know that this is NOT a client-server application. I'm using the...
See more

Part and Inventory Search

Back
Top