wwHTTPSQL::Execute
less than 1 minute to read

This high level method handles calling the remote server with the property settings made on the current object.

Implicitly calls CreateRequestXml and ParseResultXml and makes the HTTP calls 'in between'.

Generally this is the only method that you will use with this component.

o.Execute(lcSQL)

Return Value

number of records returned or 0 for non exec commands. -1 on error. Also ALWAYS check lError.

Parameters

lcSQL
Sql string to be executed on the server

Example

foxpro
oHSQL = CREATEOBJECT("wwHTTPSQL") oHSQL.cServerUrl = "http://localhost/wconnect/wc.dll?http~httpsql" oHSQL.cSQLCursor = "TDevelopers" * ** Plain SQL statements lnCount = oHSQL.Execute("select * from wwDevRegistry") ? lnCount IF oHSQL.lError ? oHSQL.cErrorMsg ELSE BROWSE ENDIF

See also:

Class wwHTTPSQL

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