Search results for query: *

I think you're trying to tackle this from the wrong side. It's in the interest of the users you don't have oplock problems on their LAN, so make it a requirement of your software to establish the leasing mode settting, otherwise you'll not warrant for the flawless working of your software...

https://www.berezniker.com/content/pages/visual-foxpro/vfp-90-versions You have the lat4est version SP2 plus Hotfixes. SP2 would bring you back to 9.00.00.5815 I mean you could download and check for yourself, which version number the properties of the VFP9.exe file has. It's not only about the...

One thing I know is causing seemingly unsolvable trouble is a phenomenon of controls being invisible unless you mouse over where they should be. VFPs Windows themes support is causing this, but you can turn it off globally by setting _Screen.Themes=.f. or call SYS(2700,0) or both. Since FPDOS...

VFP9 is still downward compatible with FP 2.6, and Tore is an expert and has already done such conversions. You still think in terms of rewrite, you can take most of your code 1:1. You'll end up seeing your DOS screens in a Windows form, that's mostly what changes. From the perspecitve of user...

Not sure what that means. Is that fine or a problem? Of course you would then use win2pdf to convert a TXT after having the TXT, but here's how you would be able to do that as soon as possible, even if you'd not be in control when the TXT is fully written and closed by a printer driver: After...

Thanks. The idea of the masses of data being a problem is about a scenario where you did not only need to decide about two rows, but have very many same transactions that are each candidate to need an update. Indeed it then becomes unimportant which one to pick manually and keep the others. So...

To carve out the essence in Mandy's case and in the light of Doug Lindauers question what's the use of a primary key in tables that are not referred to in other tables, i.e. not ever used as foreign keys. Technically you can have such tables without primary key, they are called heaps. And you...

For long term strategies it surely is good to get into alternatives to COM/OLE automation. But for an office 2019 that's not the problem. It's fixable with correct Office installation. By the way, the "on demand" version was later named "click-to-run" which may be what you deal with, here. In...

That's true, but you wouldn't have a constant identifier. And that wouldn't make it a primary key. Edit: And that's what MarK also posted before me. So the question becomes, whether it is okay to have a table without a primary key. You find a lot of discussion about it. One major point is it...

How? If they have Office on demand, the information within Excel will show a version that looks like a desktop version, quacks like a desktop version, but still isn't a duck. It's not installed with the necessary registry keys for the automation servers to be usable. Anyhow, you can't automate...

It's a sign the Office version is not installed as desktop version, but as "Office on Demand", where the office application you use is streamed but not actually installed. Such an Office version can't be automated.

I interpret Mandy's explanation of her tables as the main table having an idnum and the transaction tables first column is referencing that, but has no own idnum. Take a look at the 3 001 values in the transaction table. That's not it's primary key idnum, for sure, as that wouldn't allow double...

Great data example of MarK. Notice that many-to-many relationsips are not rare, but still simpler 1-to-many relationships are more normal. And the curXCross in MarKs example, which I suggested to either be studentcourses or a coursestudents is nothing else but two 1-to-many relationships that...

Very specifically in VFP, as MarK already posted and recommended, you have the concept of the current record in a workarea, in which you open the table. UPDATE-SQL does not have that concept, but REPLACE only replaces in the one, current record, unless you add the ALL or a FOR filter clause that...

The structure of your transaction table is missing a unique ID column, every table should have that, no matter if it's a main table or not. Especially the detail/child tables that have a reference to a main table are not identifying records by that reference uniquely, i.e. you have many...

Okay, that explains and also confirms what I already told you: That the connection is made and the error "access violation" originates from the MariaDB Server after the connection. Not what I expected, but there you are. It does not match what you told: That you tested in a separate PRG making...

Okay, but then you must do something in code that does (re)set the grid.recordsource, otherwise you wouldn't get a reconstruction effect. You could use the Class Browser (from Tools menu), Click the open icon, change file type to form in the file open dialog, choose your scx, then click on...

Well, to open a table before even starting a form, you depend on the form not having a private datasession. It's better to have a private datasession, though,, and thus open the tables the form needs within the form Load or DE or Init and not before starting the form. Indeed the simplest...

To show an example: 1. create a new project you call "progress" 2. create a main.prg as main program of the project with this code: Define Class GIF as Form Olepublic Add Object Image1 as Image Caption = "" BorderStyle = 0 ShowWindow = 2 ShowInTaskBar = .F. GIF = ""...

Thanks for the heads up on this. As I said earlier the OS should care about the animation, once the GIF is set up as picture property, at least there's nothing to code on the VFP side. So it seems the OS does not have an own GDI+ related process or thread that does the automation time scheduled...