MasterFieldsNullable, SmartFetch

Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
dschuch
Posts: 73
Joined: Thu 05 Feb 2009 15:29
Location: Dresden

MasterFieldsNullable, SmartFetch

Post by dschuch » Mon 26 May 2014 17:51

Hi,

are there any further Informations about this 2 new properties?

* MasterFieldsNullable => so far, so good, will this also prevent a server call if the master field in the master dataset is null? if MasterFieldsNullable=false, there never will be a result of the detail, so the detail could be disabled/closed until the master field has a value

* SmartFetch => here i cant imagine what this will do, any help link?

ty.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: MasterFieldsNullable, SmartFetch

Post by AlexP » Tue 27 May 2014 08:35

Hello,

1) MasterFieldsNullable allows to take into account Null values in the fields, by which the relation is built when generating the query for the Detail table. Independently on this property value, the query will be executed on the server. We can't ourselves close the DataSet (even if the field is NULL). Such behavior must be implemented manually.

2) We will add description of this option to the help shortly.

dschuch
Posts: 73
Joined: Thu 05 Feb 2009 15:29
Location: Dresden

Re: MasterFieldsNullable, SmartFetch

Post by dschuch » Wed 28 May 2014 00:04

Thanks for your awnser

1) ok, but u could do a Truncate/ClearAllRecords in this case. Its shure that the server call will result in an empty dataset, so why call the server for this.

2) so im excited ;)

Daniel.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: MasterFieldsNullable, SmartFetch

Post by AlexP » Thu 29 May 2014 14:42

1) I don't quite understand what your questions are about. Could you clarify what you mean?

Post Reply