Search results for query: *

Performance for reporting is subjective based on how often you need to run the report, Keep in mind that even when the range varies, a permanent table can still be used because although I didn't mention it, you would be using a range in your query so it's still optimized for current and future...

My two cent... If this is something you will do often, you can improve the performance by creating a permanent table instead of a temporary cursor so it doesn't have to keep creating it and deleting it on the fly. The other advantage is that you can also place an index on the serial column...

I stand corrected. As I said, I only use NODEFAULT in rare circumstances, such as when I want to bypass the keypress event. As you said, we have plenty of discussion here about DODEFAULT such as the last time we talked about it here...

I've always loved and hated that part about Object Oriented Programming. Years ago I made it a point to implicitly add DODEFAULT() either at the start or end of most of my custom classes, just to be sure they fire WHEN I want them to, and I use NODEFAULT() for the handful of times I need them...

PS... I should clarify. I posted before thinking about what I said. If you want the new class to run ONLY the new code, add NODEFAULT() to the child. Otherwise, you can place DODEFAULT someplace else, such as before or after the new method code.

My final 2 cents... The most confusing thing for some people is that when you create a class based on another class, people have a tendency to forget that when you create new code for an existing event, that code is used AFTER the original unless you call DODEFAULT() somewhere else in the...

If your main problem is placing your custom control inside a container using the IDE rather than code, it's just a matter of knowing where things are. As Chriss said, there is a definite hierarchy and when there's a container you can place objects into it by doing two things, right click your...

My 2 cents about the first and last of month is that since they come up so often, it's a good idea to have a quick UDF for both so you use them on the fly when you need them. There are likely a bunch of UDFs in the forums just like the one from @wOOdy-Soft (FirstDayOfMonth) posted with various...

My guess is that your SET DEVICE TO FILE is either pointing to an invalid location, an invalid filename, or the user does not have sufficient write access to that location.

In case anyone is curious why there is a constant for HKEY_LOCAL_MACHINE, Handles for the major sections are in Hex Here's a list of all the possible values. https://www.rubydoc.info/stdlib/win32/2.1.6/Win32/Registry/Constants

7423 is SP2 with the security patch. Technically, Microsoft Service Packs were their way to distribute a combination of fixes and enhanced or changed features, but patches are just fixes.

I'm neutral about VFPA. I made several payment as donations to support the developer because I like the idea that if Microsoft ever follows Apple's lead in removing support for 32-bit (which is VERY unlikely), I'll still have a way to deploy my code. That said, if I decide to do a test with a...

Confirmed. The only thing that changed is the date of the web listing. Inside the MSI are the following files, which are dated from 2012. The end result is the same

The 2024 date is what's interesting. Now I'm curious. I'm wondering if they just moved the Service Pack or actually did a patch. The KB it referenced is a broken link, and the Security Bulletin is over 12+ years old, so I'm guessing it was just moved and they posted a new date. Either way...

Yes, once the Wizard creates your form, you can change anything from the Properties window just like a form you created from scratch. If you want to allow users to select a language and change the Caption on the fly, you can do that in the Init method as @GTGeek88 pointed out.

One possible cause is that you may not be using the textbox within the column. To confirm this, drill down from the column to get to the underlying textbox and check the control source for that specific box.

If you are running FoxPro for DOS on a 32-bit Windows based system you could trigger Windows to show the image, then hit alt-tab to switch back to the DOS screen or the command window. To trigger the default viewer for the image in Windows just use RUN START imageFileName and it will likely...

We are 100% in agreement. They definitely could've changed the behavior because it does in fact let each work area have independent readonly vs readwrite as long as the first file was not using NOUPDATE, so the underlying code is flexible enough under the hood to manage each work area's status...

It makes 100% for exclusive use for lots of reasons, because you need to ensure other users can't access a file until you're done, but within the same session it would've been a better decision to open the files the same way and let the presence or lack of NOUPDATE determine what that work area...

Great insights. For those who are curious, you can see this demonstrated in real time by looking at the Open Files section of a file server, then sort by the # of Locks tab. 99% of the files will have zero locks, then if you refresh the page, the locks come in and out of existence as the locks...