Category Archives: Delphi

Delphi. FireDAC. BLOB

Example from project shows writing in parent table and blob table

Theory from Embarcadero site Embarcadero The BLOB streaming technique implements BLOB parameter values streaming to / from a database. This allows to transfer a BLOB value “by reference” in contrast … Continue reading

Posted in Delphi | Leave a comment

Delphi. FireDAC. FastReport. MasterDetail. Example from project

qSelectEventUsers – 1st query Note: we use UsersID, eventsID as field alias

setup DataSource

qSelectEventUsersElements – 2d query Note: we use UsersID, eventsID as param

setup 2-d query

setup FastReport components frxDBDataset_qSelectEventUsers DataSet:=DS_EventUsers UserName:=frxDBDataset_qSelectEventUsers frxDBDataset_qEventUserElements DataSet:=qSelectEventUsersElements … Continue reading

Posted in Delphi | Leave a comment

Delphi. VCL. FastReport. Manual

https://www.fastreport.ru/public_download/docs/vcl/UserManual-ru.pdf

Posted in Delphi | Leave a comment

Delphi. FireDAC. MasterDetail

Source. Embarcadero To set up a master-detail relationship, this sample uses the Object Inspector to configure the following components at design time as follows: Two TFDQuery objects named qryOrders and qryOrderDetails. These components are used to implement a dataset capable of executing SQL queries. The following setup is … Continue reading

Posted in Delphi | Leave a comment

Delphi. MVC pattern in UniGUI vs traditional coding to form

My discussion on forum Conclusion – mvc is possible to implement, but not obligatory. Standart delphi structure of dfm and pas is natural to delphi enviroment. Maybe mvc pattern would be better for big projects…

Posted in Delphi, UniGui | Leave a comment

Delphi. UniGUI. Calc, just calc

Wanted to show 2 patterns on calc example, but calc itself has become not simple task… Below version that works correctly but there is things to do…

 

Posted in Delphi, UniGui | Leave a comment

MySQL. function to count ratio. Example from project

Was needed to count progress of finished / all elements,below is an example how to do this…

 

Posted in Delphi | Leave a comment

Delphi. FireMonkeyStyles

 

Posted in Delphi, FireMonkey | Leave a comment

Delphi. FastReportVCL – merge / concat many reports

I needed report from runtime and disign time to be merged, so below is simpliest way to do this…

example of use

  Building a composite report (batch printing) In some cases it is required to organize printing … Continue reading

Posted in Delphi, FastReport | Leave a comment

Delphi. FastReportVCL – change language to Russian, example

for exmaple we will change language of previewer to russian find dir where languages are (for ex.)

open cmd and type

 type

you will recieve Russian.frc file In runtime call

 

Posted in Delphi, FastReport | Leave a comment