wwHTTPSQL::AddSQLParameter
less than 1 minute to read

Adds named parameters that can be used in SQL statements or commands.

Parameters are marshalled to the server and recreated on the server running the SQL statement on the server. SQL Server will use SQL Passthrough syntax for parameters (using ? syntax) while Fox data will use straight parameters. Output parameters in stored procedures should be prefixed by both the ? and the @ in SQL Server (Execute someSP 'parm1',?@pnID).

o.AddSQLParameter(lcName,lvValue,lcType,llReturn)

Parameters

lcName

lvValue

lcType

llReturn

Example

foxpro
oHSQL = CREATEOBJECT("wwHTTPSQL") oHSQL.cServerUrl = "http://localhost/wconnect/wc.dll?http~httpsql" oHSQL.cSQLCursor = "TDevelopers" pnID = 0 pcTablename = "wwDevRegistry" oHSQL.AddSQLParameter("pnID",pnID,,.T.) && Return this one back oHSQL.AddSQLParameter("pcTableName",pcTableName) oHSQL.AddSQLPArameter("pcIDTable","wwr_id") oHSQL.AddSQLParameter("pcPKField","pk") ? oHSQL.Execute("Execute sp_ww_NewId ?pcTableName,?@pnID") *** pnID result value ? oHSQL.vResultValue *** or explicitly retrieve a return value ? oHSQL.GetSQLReturnValue("pnID")

See also:

Class wwHTTPSQL

© West Wind Technologies, 1996-2024 • Updated: 04/03/18
Comment or report problem with topic