wwHTTPSQL::Execute

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

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