Connect Property DataFactory Query Method SubmitChanges Method Refresh Method DataControl Object PROPERTY:  DataControl::SQL string = datacontrolobject.SQL datacontrolobject.SQL = string The SQL property sets or returns a string that is an SQL query that is used by RDS to retrieve the Recordset. The string must use the type of dialect of SQL that is recognized by the server. You can create a form on a Web page to input values for the various DataControl properties and use Request.Form( ) to assign the values: Code (VBScript): objDC.ExecuteOptions = Request.Form("ExecuteOptions") objDC.FetchOptions = Request.Form("FetchOptions") objDC.InternetTimeout = Request.Form("InternetTimeout") objDC.Server = Request.Form("Server.Value") objDC.SourceRecordset = Request.Form("SourceRecordset") objDC.SQL = Request.Form("SQL") objDC.URL = Request.Form("URL") objDC.Connect = Request.Form("Connect") objDC.Refresh Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved. Trademark Information