Search results for query: *

Then the problem is related to the data sessions. I never use data sessions, so I don't have any experience troubleshooting them, but I know enough to know that there are configuration options in data sessions that you can explore such as private vs default datasets (private isolates the...

"File is used by another user" sounds to me like you have used a file exclusively, or you used an FLOCK() to lock the whole file. So, before looking into the data session issues, check to be sure you have SET EXCLUSIVE OFF and that you haven't opened any tables with EXCLUSIVE or called an...

Hang in there are take care of yourself and your family. There is nothing more important than that.

I've never used devices like that with FoxPro, but as long as you can communicate with it via a standard protocol, you should be able to open a connection to it using some standard protocol like http or ftp. For example if it uses http, you can create an object to talk to it using...

I didn't think he was referring to a record number. He mentioned a column named Sifra, so assuming that's the column name, and the value in the variable N is valid, the locate would work, but as I mentioned, he would not know that it worked because the screen would still need to be refreshed...

Two things. 1. If you do a locate and find something, the form will still need to be refreshed or you will still see the OLD values. Do this with Thisform.Refresh() after the locate. 2. Whenever you do something like this, you should add some code to handle the possibility that nothing was...

I took some major shortcuts for my smaller clients. I found a couple of dirt cheap terminal server alternatives, including TSPlus and ThinStuff that run on plain Windows 10 Pro or Windows 11 Pro. I settled for ThinStuff. You can just install it, create user accounts, put icons in the...

It's definitely not for everyone, but I found a few easy ways to make it happen for my clients without any expensive hardware or software. My smallest client runs 5 terminals on a computer smaller than a Mac mini, that cost me under $700, including the software needed to run the RDS. I secure...

Agreed. I've never needed to scale a traditional dbf project that large, so there is no one size fits all. With larger numbers of users, you will still likely use a file server, but at least you won't need to adjust the optimistic locking parameters for every workstation. Thankfully if you...

My point is that RDP eliminated the Oplocks issue completely for me without asking my client's IT people to change the default SMB settings on either the clients or servers. While there still is network traffic to display the screen, it's much less traffic than you'll see if you continuously...

I'm just adding my agreement to what has been said so far. The problem is based on where the data is stored, regardless of where and how the exe is run. Before I started making Remote Desktops my main way to run my programs, I used to use two .REG files that changed the Optimistic Locking...

Distiller's been around since the very first generation of Acrobat as the engine they use to let third party programs create a PDF by treating it as a printer driver. You should experiment with the resolutions as I mentioned to see if there is any change before tinkering with settings. As I...

I don't know if it has any DPI settings, but if it does, you'll need to experiment because I don't use it. But, what I'm referring to is the resolution of your actual monitor and how Windows is interpreting it. I know for example my 5K display is 218 DPI, and that using that particular display...

You are absolutely right. I forgot about that. Although @foxup doesn't think so, I remember this exact problem with older versions of FoxyPreviewer. The problem with FoxyPreviewer was only an issue with very high resolution displays. For example, I use a 5K monitor, and it did the exact same...

This is just a guess, but the default printer has a direct effect on page sizes in FoxPro reports. So if the page sizes for the default printer are smaller, the generated report will be cut off unless you set the default to a wider printer before generating the report. You can change the...

I've used quite a few XLSX import and export hacks over the years, but they all still have some quirks, such as some approaches returning columns as Memos by default making it tough to browse the values without casting each column implicitly, but at least the data is there. Another big reason I...

Writing your own cleanup before appending is definitely a good idea because just about every file type (TXT, SDF, TAB, CSV, XLS) has some challenges. So, I'll add to your list of things to look out for by saying you should also be careful of formatting of individual columns, especially if the...

Just to be clear here, does it give you an error, or is it only executing the 1st part? In you example, are all the values saying aaa, instead of bbb... or is it not running either?

Try inserting GO between each command.

I cringe whenever I look at some of my older forms and notice they still use native controls. My standard protocol is to base all of my controls on a class I built as a standard PRG that defines every single native control with the same name but with my own prefix. Everything else is a...