Mark-

Hello, Using Delphi 10.2.3 Any advice? Anyone that made the switch then reverted to W10? Thanks, Mark

Why is W11 better than W10?

Thanks. I am putting it off for now. I have W11 running in a VM and have been looking at it. Trying to make it like W10. 😀

Yes it is possible, we and some of our customers connect to MS Access. Not the most used database, but used. From our user manual: Direct connect to the data base At least these three parameters must be present for direct connection to a database via ODBC. DriverID ODBCDriver Database A DSN can be used and then just a DataSource parameter is needed. I know it worked when I tested it but, I have never seen a user apply it. All I have seen is the first example and it is what I use. Mark

It does not work on my Notepad++.

Not the versions on my computer.

Does not work in 10.2. I just checked three other text editor programs and MS word was the only one that supported it.

Hello, Delphi 10.2.3, FireDAC, OBDC. I am using Excel for testing. When the Excel cell contains text I can set the "align" property in a TDBEdit and all is fine. The right column values are numbers and the alignment only applies when the cell is in edit mode, the "align" property of TDBEdit is applied, In "browseMode" the alignment seems to be overridden from the TFieldDataLink of TDBEdit, which is not exposed. Anyone run across this before? Thanks, Mark

Hello, Delphi 10.2.3, FireDAC, OBDC. Does an SQL query exist that can read a single cell from an Excel spreadsheet? Thanks, Mark

Thanks for the response. The syntax has a problem but, changing to SELECT * FROM `Sheet1$A1:A1` was accepted. The result is interesting. TomF, I am using FireDAC and ODBC.

Thanks for your response. It needs to be accomplished with SQL and I can say after many hours of trying, it is not possible. Excel does not provide a naming scheme to access a cell, like, "B2" via SQL queries. If it does, no one has ever documented the syntax and published it. I tried a few formats, no joy. It really, is not surprising. SQL/databases are all about records/tables and its structures. Or that is the way it appears to me. A single cell, does not fit the table name/field name paradigm.

You are welcome.

There are a few commercial MQTT clients. Or you could write your own code. The MQTT protocol is not very complicated, by design.

Yeah IIRC, a broker can select to, not answer a connect message or return an error message. Does the broker documentation state the version(s) or MQTT it supports?

What does that mean? A trace using Wireshark has no response from the broker?

What is the response? Or no response?

Sorry no. I do not use it. I would search for the 0x12 ($12), or the text of the protocol name.

The packet fixed header byte for "Connect", regardless of 3.1 or 3.11, is 0x10. The lower 4 bits of the packet fixed header are reserved. The packet fixed header byte for 3.1:

Thank you.

How about come up with an idea, fund it yourself and reap all the benefits?

When did you post it? It can take several days, from my experience.

You might want to post on the TMS forums.

True. Is that issue a negative for customers. Don't know.

Yes our previous cloud solution went to the per transaction model and our cost would have gone up over 1000%. Not going to happen. Yes, #2, the pricing page had no data. Funny, before adding code signing, many years ago, not one customer asked for it or made a comment about it. We have wondered if we removed it, would it have any negative effects.

Hello, Today, I discovered some code using mciSendCommand with MCI_WAIT and MCI_PLAY, I wrote when Windows 7 was the cat's meow works under W10 and I assume W11 as long as the user has not used CTRL + break on the computer. Searching the web I found a fellow reported the issue in 2016, https://answers.microsoft.com/en-us/windows/forum/all/media-control-interface-nmci-not-working-properly/4931db24-a53a-46da-94db-7423e3d5540f I verified, code works sound plays, press CTRL + break, code says it works, no errors and no sound. Restarting the computer, the code works as long as CTRL + break has not been pressed. And there seems to be another time it might be cleared but, I could not repeat that part. Rewriting the code without using MCI_WAIT is possible but, before I started, I was wondering if anyone has an idea or has found a solution? Thanks, Mark