[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] Reference for unit 'SQLDB' (#fcl)

TSQLQuery.UsePrimaryKeyAsKey

Should primary key fields be marked pfInKey

Declaration

Source position: sqldb.pp line 711

published property TSQLQuery.UsePrimaryKeyAsKey : Boolean;

Description

UsePrimaryKeyAsKey can be set to True to let TSQLQuery fetch all server indexes and if there is a primary key, update the ProviderFlags of the fields in the primary key with pfInKey.

The effect of this is that when UpdateMode equals upWhereKeyOnly, then only the fields that are part of the primary key of the table will be used in the update statements. For more information, see UpdateSQLs.

Note that this property only takes effect if the fields are the default fields: if persistent fields were created, the providerflags of the fields are not updated.

See also

TSQLQuery.UpdateMode

  

How to create update SQL statements.

#fcl.bufdataset.TCustomBufDataset.Unidirectional

  

Indicates if the dataset is for uni-directional navigation only

TField.ProviderFlags

  

Flags for provider or update support

pfInKey

  

What to do with fields when applying updates

UpdateSQLs

  

Automatic generation of update SQL statements


Documentation generated on: May 14 2021