Search options (Page 5 of 34)

Hi Roberto

procedure Form1_OnKeyDown (Sender: TObject; var Key: Word; Shift, Alt, Ctrl: boolean);
begin
  if (Ctrl) and (key=107) then showmessage('You press "+"');   // PLUS on NumPad
  if (Ctrl) and (key=109) then showmessage('You press "-"');   // MINUS on NumPad
end;

Roberto, use my second example without FLOOR and MOD.

select PRINTF('AMD: %02d %02d %02d',
                         alldays / 365250 ,
                         (alldays % 365250) / 30437 ,
                         ( (alldays % 365250) % 30437)/1000 )
from (select 
    (julianday('now','localtime') - julianday('2022-12-23'))*1000 as alldays  ) as t;

You can't just change '%' instead of MOD,
using '%' instead of MOD has its disadvantages.
Therefore, we operate with integers.
Look at the results, false and true:

select PRINTF('AMD: %02d %02d %02d',
                        cast((alldays / 365.25) as integer),
                        cast(((alldays % 365.25) / 30.4375) as integer),
                        cast((((alldays % 365.25) % 30.4375)) as integer))    
from (select 
    (julianday('now','localtime') - julianday('2022-12-23')) as alldays  ) as t;

AMD: 00 11 04  < -- FALSE

select PRINTF('AMD: %02d %02d %02d',
                         alldays / 365250 ,
                         (alldays % 365250) / 30437 ,
                         ( (alldays % 365250) % 30437)/1000 )
from (select 
    (julianday('now','localtime') - julianday('2022-12-23'))*1000 as alldays  ) as t;


AMD: 00 11 30 < -- TRUE

As Derek and Konstantin wrote, the component does not have a name.
And the dynamically CREATED component has index 21.
Therefore frmdbCoreUserForm.components[21] ... . This is how you can reference it.

I wrote it that way.

And when this form is ready for display (or has already been created), the combo becomes available for working with it))).
In other cases, there is a component error with this index.

The FastReport script is no different.
You need to read the documentation and you will get an idea of how FastReport events work and how the output is generated on the screen.
Here is the link: https://www.fast-report.com/public_down … ual-en.pdf
FastReport's capabilities, which are described in the manual, are slightly larger. But you will get an idea of how it all works, including in the script.

If you look closely, you will see that the LAST result - Tery - is not displayed.
And if you look at your code, you will see that the previous driver is displayed when the driver is changed DriverName <> currentDriver. But the condition does not work for the last driver.

Implementing such a solution through the FastReport script will require significant effort and programming knowledge from you.

Once again, Derek's solution is optimal and requires a little modification to achieve the result you need.
Ok, I'll do it for you.
Here is Derek's modified solution in two versions.

Ваш запрос выглядит мягко говоря - никак

Найдите сначала подзапросом запись которая относится к МАХ(Дата)
А уже к ней присоединяйте что хотите.

И читайте, читайте, читайте.

Улыбнуло
Вокруг столько литературы, сайтов, примеров ...

Кстати вы привели пример CROSS JOIN даже не подозревая об этом.

Не совсем понятно о чем вы говорите.
Основную таблицу выборки вы выбираете сами так же как и соединение с другими таблицами,
исходя из того результата который вы хотите получить.