Stano

Professional Delphi does not have FireDAC resources !!!

My layman's view and experience: I, as a non-programmer, am behind DBWorkbench. The main reason for me is Visual Query Builder. It's incredibly sophisticated. You need to get used to it, but working with it is very pleasant. In addition to the Editors! There they limp a little. (But so do the others.) If you have a parenthesis, you don't know where the cursor is. The high award is for their support. I had a few problems (they actually had them) and some suggestions. They reacted quickly and almost everything was reflected in the product I had IBExpert - I messed up the OS and they didn't renew my license. It kind of didn't fit me I have EMS SQL Manager - it has a few good things, but overall it's not comfortable. Text selection, etc. I tried Red Manager (?) - That was at the beginning of its development. It's free. I don't know what condition he is in now. I think the start-up was good. They are also developing RedDB. Just for interest. The Arabs invest in it and the Russians make it. So they have enough money. I write it directly

What happens if you add over time WITH XX AS (... ?

Exactly. I'm all the happier

We need to look at what has been fixed. The vast majority are HDPI. Nothing for me. From my experience: forms open faster the Welcome window closes faster That is probably all

Probably like point 2.

Reasons, not reasons I'm like one-armed

I as a non-programmer: FixInsight - I use it continuously. Depending on the situation. You can check the whole project or just the current unit (that's instant) EurekaLog - without it (or other similar products) it is out of the question Tests - I can't do them. That's why I test everything manually. It's tiring. I don't like it at all. I have to force myself into it GIT - I only use it as an archive. I don't do any branches or test versions Your whole process skeleton looks logical and good

CnPack

Ctrl + click also doesn't work for me sometimes. I just have such a mini project But the "Find Declaration" popup menu works

Correct should be ... WHERE MyDateTime = CAST (: MyDate AS DATE) ... Avoid using "StrToDate" functions. You will avoid the problem. Use functions from the EncodeDate family I was inattentive again.

Now server

As far as I know, that is the basic role of transactions. It is about covering data integrity.

Does not exist

A matter of taste. In the vast majority of cases, I turn it off. It's usually on the last page.

I do not need this. But I also don't have it on offer.

I don't think he's interested in D11. One reason: their tool has already been partially implemented in D11.

To buy a new version

I was very surprised by the data on SQLite

No problem for me. Simply, I don't use it. I read somewhere that these components, in this case, unnecessarily slow down the IDE.

Oh, I didn't remember that.

Please how to remove Live Binding? Thank.

It's all homework. Of course you need a JOIN. You get ITEMNO params using a separate SQL. You will pass this query in a while loop, and you must update the table in each loop. Try writing something first. Put it here and we'll comment. It won't matter if it's wrong. If we write it to you, it will lose its effect. I don't want me to get ready-made solutions either. Only when I can't handle it. You can put it here in pseudo code. You will have it easier. That's the way to do it.

UPDATE ItemCard SET RESERVED = (SELECT ItemCard .RESERVED - Detail Table.QTY FROM ....) WHERE ITEMNO = :ITEMNO Gradually ParamByName('ITEMNO') := AAA; BBB; CCC All in a cycle in a single transaction!

Yes