Is ProviderFlags used in SDAC

[siatc1]

Hi,

I tried to set the ProviderFlags.pfInUpdate of one of the persistence field to False. But somehow SDAC will still include this field whenever I update the record. Any other setting to watch out for?

Thanks

[Ikar]

The flag ProviderFlags.pfInUpdate isn't used for automatically generated
update queries. To avoid sending to server these fields, you should set your update statement to SQLUpdate property.
Example:

Value of the SQL property:

Code: Select all

Select id, f1, f2, ReadOnlyField from AnyTable

Value of the SQLUpdate property:

Code: Select all

UPDATE AnyTable SET f1 = :f1, f2 = :f2 WHERE id = :old_id

To simplify generating SQL statements you can use SQL Generator at design time.