Is ProviderFlags used in SDAC

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 8
Joined: Fri 13 Jan 2006 05:58

Is ProviderFlags used in SDAC

Post by siatc1 » Tue 24 Jan 2006 06:48


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?


Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Tue 24 Jan 2006 13:18

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.

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.

Post Reply