Stano

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.

Remember: is the entered value valid?

As far as I know, with limited rights.

I used Format uses clause. I would like FireDAC.xx.yy to form a separate group as a System.xx, Vcl.xx and etc. That there is them FireDAC.Comp.Client, BasalForm, FireDAC.Stan.Param, FireDAC.Comp.DataSet, FireDAC.Stan.Intf, FireDAC.Stan.Option, FireDAC.Stan.Error, FireDAC.DatS, FireDAC.Phys.Intf, FireDAC.DApt.Intf, FireDAC.Stan.Async, FireDAC.DApt,

It happened.

You forgot one piece of information. What a component it is.

If you own a D professional and are considering a DB server, I wouldn't even try FireDAC