This method returns a collection that can be populated with values you can pass to the ExecuteSQLStatement method as the parameters to send to a stored procedure or you can pass to the GetValuesForField and GetValuesForParameter methods as the default values.

The collection has an AddItem method that expects two parameters: the name of the value object and the value to assign to it.

Syntax

GetValuesCollection() as Object

Return Value
A collection to hold value objects.

Example
This example is taken from the end of an example in the Select help topic. It calls GetValuesCollection to create a values collection, adds two values to it, and then passes the collection to ExecuteSQLStatement to be used as the parameters for a stored procedure.

Visual FoxPro

if not empty(ldStartDate) and not empty(ldEndDate)
  loValues = toApplication.GetValuesCollection()
  loValues.AddItem('Beginning_Date', ldStartDate)
  loValues.AddItem('Ending_Date',    ldEndDate)

* Execute the desired stored procedure.

  lcSelect = 'exec [Sales by Year]'
  llReturn = not empty(toDatabase.ExecuteSQLStatement(lcSelect, ;
    loValues, tcCursor))
endif

C#

if(startDate != null && endDate != null)
{
  Values values = SQApplication.GetValuesCollection();
  values.AddItem("Beginning_Date", startDate);
  values.AddItem("Ending_Date", endDate);

  // Execute the desired stored procedure.
  string select = "exec [Sales by Year]";
  bool returnValue = (database.ExecuteSQLStatement(select, 
    values) != String.Empty);
}

VB.NET

If Not startDate = Nothing And Not endDate = Nothing Then
  Dim values As Values = SQApplication.GetValuesCollection()
  values.AddItem("Beginning_Date", startDate)
  values.AddItem("Ending_Date", endDate)
  ' Execute the desired stored procedure.
  Dim selectString As String = "exec [Sales by Year]"
  Dim returnValue As Boolean = (Database.ExecuteSQLStatement(selectString,
    values) <> String.Empty)
End If

See also

Application Object

© Stonefield Software Inc., 2023 • Updated: 06/06/16
Comment or report problem with topic