Search results for query: *

Interestingly, an empty comment /**/ also does not work. To get # to work it can't be the first character, you have to precede it with a space, and like -- it only works with a CR LF. However, I stick to what I said earlier, such empty non queries working doesn't prove the connection is...

Atlopes, our posts crossed. I checked executing nothing or a comment. Most variations of that return -1, just one version works: SQLEXEC(h,'/* */') While, accoring to https://mariadb.com/kb/en/comment-syntax/ comments could also be --, as you suggest, and #. Besides SELECT Now(), which may not...

First of all, thanks for pointing out, that way I don't have to come up with that topic to state that for I'd generally now recommend MariaDB over MySQL. DO is still a MariaDB command (https://mariadb.com/kb/en/do/) so the detail question just becomes why you can't execute DO 1, specifically...

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