InsertSQL property

Applies to
TIB_Dataset

Declaration
Property InsertSQL : TIB_StringList;

Description
This property works just like the TUpdateSQL.InsertSQL property.

For example:


INSERT INTO MYTABLE ( MYCOL1, MYCOL2 )
VALUES ( :MYCOL1, MYCOL2 )

IBO automatically generates an INSERT statement for the typical cases so this property will most likely only become useful to provide a way to pass parameters to a stored procedure that will perform more involved operations in roder to effectively produce a record in the dataset.

This could be a case where you are using a stored procedure derived dataset or a dataset across a many-to-many relationship and you need to also insert a record into the junction table. Thus, it can make it seem as easy as working with a master-detail when actually it is a master-master-detail relationship.