Search options (Page 148 of 400)

Здравствуйте.

В вашем случае необходимо использовать ключевое слово HAVING, попробуйте так:

SELECT
strftime('%d.%m.%Y',in_out.data),
in_out.IDG,
total(in_out.INN),
total(in_out.OUTT),
total(in_out.OUTT)- total(in_out.INN),
total(in_out.discount),
total(in_out.discountOut),
total(in_out.discount)- total(in_out.discountOut)
FROM in_out

WHERE (in_out.data >= {dtFrom}) AND (in_out.data <= {dtTo})

GROUP BY in_out.IDG

HAVING (total(in_out.discount)>0) AND (total(in_out.discountOut)>0) AND ( total(in_out.discount)- total(in_out.discountOut)>0 )

ORDER BY in_out.data

Unfortunately I can't find any photos in your post.

timlitw
Please attach your example project.

Please attach your project (zip file without exe and dll)

If you enable Cascade delete, you will not to get a message, like in the first your post.

procedure Form1_bDelete_OnClick (Sender: string; var Cancel: boolean);
begin
    if MessageDlg('Deleting this record you can loose other informations', mtConfirmation, mbYes+mbNo, 0) = mrNo then
    begin
        Cancel := True;
    end;
end;

Используйте кнопку с действием "SQL запрос", который заполнит грид необходимыми данными, затем используйте кнопку с действием "Открыть в Excel"

6katran6
Вам необходимо сортировать TableGrid или ComboBox ?

Please provide more details.

Hello.

Unfortunately it's not support in the current version, but I will try to add this in the next version.

Thanks.

Hello.

You can not delete record, if this record have relationship from another table.

For example, you cannot delete an employee record from the Employees table if there are orders assigned to that employee in the Orders table. You can, however, choose to delete a primary record and all related records in one operation by selecting the Cascade Delete options for foreign key.

К сожалению в текущей версии данная возможность не реализована, постараюсь ее реализовать в следующей версии.

AD1408
Hello.

For component Reportnote set property StrechMode = smActualHeight

for MasterData1 set property Stretched = True