QuerySize (Property)

Applies To:

QuerySection object

Description:

Returns the estimated number of rows the current query will return if processed.

Action:

Read-only, Integer

Example:

This example shows how to check the size of the query before processing and ask the user if they want to process the query given the size:

var MyCon = ActiveDocument.Sections"Query"].DataModel.Connection
MyCon.Username = "Hyperion"
MyCon.SetPassword("HyperionHyperion")
MyCon.Connect()
var QS = ActiveDocument.Sections["Query].QuerySize
if (QS > 5000)
{
      var Msg = "The query you are about to run, returns "+QS+ rows. "Are you sure you want to continue?"
      var retVal = Alert(Msg,Alert,Yes,No)
      if (retVal == 1)
            ActiveDocument.Sections["Query"].Process()
}