How to Insert/Edit Rows in Firebird Dataset in Delphi using FIBPLUS Components?

How to Insert/Edit Rows in Firebird Dataset in Delphi using FIBPLUS Components?

You can insert a row and edit an existing row in firebird dataset in Delphi. I will use FIBPLUS dataset component in Delphi XE4. Just use Insert and Edit procedures for this purpose. First of all create a dataset of type TpFIBDataset. Lets have a look at this very simple example.

var

dsMyFirebirdDataset : TpFIBDataset;

Insert a row in a dataset

with dsMyFirebirdDataset do

begin

Insert;

dsMyFirebirdDatasetID.AsInteger := 101;

dsMyFirebirdDatasetDESC.AsString := 'Hello';

Post;

end;

You can also use FieldByName like following:

with dsMyFirebirdDataset do

begin

Insert;

FieldByName('ID').AsInteger := 101;

FieldByName('DESC').AsString := 'Hello';

Post;

end;

Similarly, you can edit a record/row in the dataset like following:

Edit a row in a dataset

With dsMyFirebirdDataset do

begin

Edit;

dsHdwPriceGroupDESC.AsString := 'Hello World';

Post;

end;

or

With dsMyFirebirdDataset do

begin

Edit;

FieldByName('DESC').AsString := 'Hello World';

Post;

end;