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 Andrzejek 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. Joe Crescenzi

    Visual FreePro Update

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

    Arduino or other board with Microsoft Foxpro

    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...
  3. Joe Crescenzi

    Go to (n) record where n is thisform.text1.value

    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...
  4. Joe Crescenzi

    Go to (n) record where n is thisform.text1.value

    ...do something like this, you should add some code to handle the possibility that nothing was found. So you could do something like this: Locate for Sifra = n if found() thisform.refresh() else MessageBox("Not found") ** put something here to go someplace else, then refresh again. endif
  5. Joe Crescenzi

    Oplock when installed on local pc but data is on network server?

    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...
  6. Joe Crescenzi

    Oplock when installed on local pc but data is on network server?

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

    Oplock when installed on local pc but data is on network server?

    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...
  8. Joe Crescenzi

    Oplock when installed on local pc but data is on network server?

    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...
  9. Joe Crescenzi

    Oplock when installed on local pc but data is on network server?

    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...
  10. Joe Crescenzi

    strange report behavior

    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...
  11. Joe Crescenzi

    strange report behavior

    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...
  12. Joe Crescenzi

    strange report behavior

    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...
  13. Joe Crescenzi

    strange report behavior

    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...
  14. Joe Crescenzi

    append from tab delimited - intersting effect (or bug)

    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...
  15. Joe Crescenzi

    append from tab delimited - intersting effect (or bug)

    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...
  16. Joe Crescenzi

    Sending multiple commands to MySql backend through TEXT...ENDTEXT

    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?
  17. Joe Crescenzi

    Sending multiple commands to MySql backend through TEXT...ENDTEXT

    Try inserting GO between each command.
  18. Joe Crescenzi

    SetFocus not working

    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...
  19. Joe Crescenzi

    SetFocus not working

    Yes. You are correct. I was thinking more about custom controls. I tend to have tons of my own classes and totally custom methods that I either enhance by pushing my DODEFAULT() somewhere at the top or bottom, in in some cases as I mentioned, conditionally depending on some condition.
  20. Joe Crescenzi

    SetFocus not working

    Good Good point. I forgot to mention the option to NOT run the default at all. I generally use a DODEFAULT() somewhere in my overrides, especially of my custom controls. Sometimes I want my default code run first, sometimes last, and other times last. When using code like this on a custom...

Part and Inventory Search

Back
Top