Category Archives: Delphi

Delphi.FastReport. fr3 and fp3 difference

Hello. Has a task to save prepared reports and open them later in fastReportViewer, Spend 4 days to write this .fr3 is a model – it doesn’t contains data .fp3 is a data, prepared report So, how to save prepared … Continue reading

Posted in Delphi | Leave a comment

MySQL. Cursor. Example from project

What is cursor – it is like query that returns some dataset… but all code works on SQL server side… Code by my friend…

 

Posted in Delphi | Leave a comment

Delphi. System.ZIP Simple Examples

example from project… zip file

unzip

more info

Posted in Delphi | Leave a comment

Delphi.FastReport. Batch and unbatch reports. Buggy way on concat

Although in docs there is a sample of concating reports – it is a buggy way for some reasons… Problem 1 i’ve already posted that function that concat reports but it well concats dynamically generated reports, if one of them … Continue reading

Posted in Delphi | Leave a comment

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