Stano

My experience is to have it in the interface section.

I don't read carefully.

As you wrote it. If the condition is met, the code is executed in her body. There is nothing there, nothing will be done. If you ran a control tool, it would tell you that you have something empty.

I checked the translation where "and I don't create an runtime TFDQuery" But it is also created in the demo. There is a bad translation (Google translator) or a communication error somewhere I never use a construction with the "with" I already understood that - "with"

I don't understand "I'm not creating a TFDQuery runtime". TFDQuery is, of course, used in the example. Can you give a sample / description?

1 - I didn't mean that 2 - It is true. Personally, I haven't encountered a performance issue yet. But I don't have many records. I learned to use "with x as". It's my favorite technique 3 - Many rows = many errors interesting. There is no point in talking about the parameters. Without it, it is very bad. I plan to move to UniDAC. I don't know if he supports it. Thanks!

I cough.

Brave and MS Edge.

The link is incorrect

Serge_G - I have a question for you. Perhaps the founder of the topic forgives me. What is the advantage of your solution over subquery? I see a lot of unnecessary code I usually use subquery and I'm happy with it. Also because I don't know other techniques

CnPack, MMX, Bookmarks and Project Magician

Well thank you. I didn't find it through the basic settings. I didn't run anything from the command line. I'll wait, I'll see.

Only now have I realized that I use EurekaLog in the application Therefore, he cannot capture anything. Can EurekaLog be set up to catch exceptions in the IDE?

I use EurekaLog. It won't catch anything. At least that's how I remember it

That's right. I will translate: SELECT MAX (TDATE) FROM MYTABLE) - 10 = 3.6.2022. Note: 10 <> 3 The condition should be: MyDate <= RequiredDate

I'm an amateur. My attempt to find out some information ended quickly because I couldn't get anywhere by stepping.

I. Unfortunately, this is not a rare phenomenon. I have to restart the IDE because the error keeps recurring.

I avoid AutoInc. Reason: I have no control over him. I basically get it and I can do whatever I want with it. I know it has the right value. What can be a problem with multiple (multiple users) access to the DB. Only now has it been resolved here. This is very important when bulk editing data.

I forgot about that. But in the editor, as I explained the question, it doesn't work. I basically use a visual builder for SQL query text. It saves time and especially nerves

To take it literally: no results can be displayed during editing.

Um, they advised me, and I follow that. Query the ID value in advance and use it in SQL. If you fail, you drop it. I have no idea if this can be done in your case. I do not have knowledge and skills.

object vilLitD: TVirtualImageList DisabledGrayscale = True Images = < item CollectionIndex = 0 CollectionName = 'button_rounded_blue_first' Name = 'button_rounded_blue_first' end item CollectionIndex = 1 CollectionName = 'button_rounded_blue_previous' Name = 'button_rounded_blue_previous' end ... ImageCollection = dtmdBasic.icDBNavD ImageNameAvailable = False Left = 50 Top = 30 end OK. See dfm.

If I understood the instructions well, VirtualImageList converts images according to DPI. Therefore, they must be on every form. So only one image size should be enough. If I misunderstood, correct me.

I have a problem with the width of the breakpoint space

If you mean me, yes. Your answer is more than weird. E.g. what about aaabbbcccddd ....? I assume you know what you're doing. Text length can be affected by: by setting a value in the DB component by defining in the DB table field used database I'm in the habit of combing each text string with leading and trailing chars (spaces) before saving it in the DB.