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.