To this end, the sample offers three buttons: Once the main components are configured at design time you can run the application and interact with the sample in run time.
To this end, the following setup is needed: DBMemo1 is used to display the blobdata field of the dataset. In this sample, it is used to provide communication between the dataset and a TDBMemo object named DBMemo1. This component provides an interface between a dataset component and data-aware controls on a form. A TDataSource object named DataSource1.It means that the stream is used to read the database BLOB value. The StreamMode property is set to smOpenRead.It means that the stream will be read and written to a database BLOB value. The ParamType property is set to ptInput.The DataType property is set to one of the BLOB data types.The SQL property of qSelect is set to select * from (blobdata) values (:blobdata).It specifies the SQL statement to execute for the query. Set the SQL property for both objects.In both cases it is set to FDConnection1. Configure the Connection property of both objects to specify the FireDAC connection object that is used to connect to a DBMS.These components are used to implement the datasets capable of executing SQL queries.
Two TFDQuery objects named qSelect and qInsert.Navigate to the location given above and open BlobStreams.dproj.īefore running the sample, the main components are configured at design time using the Object Inspector as follows:.
Search by name into the samples repositories according to your RAD Studio version.
0 kommentar(er)
