38 users using DBSP now!
Home  I  Company  I  Services  I  Documentation  I  Downloads  I  E-Support
home -> documentation -> language reference -> NoMasterSource property


Description

Optional in DATASET and QRYEXEC elements, the NOMASTERSOURCE property indicates that the current SQL Statement will not have a master SQL statement (like the master detail relationship) although is nested inside a DATASET element.


Syntax

<#DATASET ALIAS="AliasName" QUERYID="NumberQuery">

  <#DATASET ALIAS="AliasName" QUERYID="NumberQuery" NOMASTERSOURCE>
    ...
  <#/DATASET>

  or

  <#QRYEXEC ALIAS="AliasName" QUERYID="NumberQuery" NOMASTERSOURCE/>

<#/DATASET>


Applications

This option is useful when you have nested SQL statements and you don't want that the outer DATASET controls the parameters of the inner SQL statement.


Note: Remember that master-detail relationships will only be established when you use typed parameters inside the SQL sentence. For more information about this topic, go to Using variables inside SQL sentences.

References

The name NOMASTERSOURCE is used in the DBSP tags:

DATASET
QRYEXEC