Recent content by rlawrence

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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