Home Information PDF Documents EULANDA Handbooks Training Book's corner Download Contact us Table of Contents About us

Glossary

Password needed Newsgroup

Remote Support system

Method: Client.ExecuteSql (iScript)

Back | Level back

Set Recordset = Client.ExecuteSql(Command, CommandTitle)
Client.ExecuteSql Command, CommandTitle

Parameter

Command

The SQL code to be carried out.

CommandTitle

A short precise heading for that carried out order. If the execution of the order lasts more than 3 seconds, the title will be shown in a "Please wait" window. Example:

    Statistic data will be determined
    Orders will be transformed

Recordset (Return value, Optional)

If the SQL command retrieve the data over a SELECT command e.g., you receive the dataset of the type ADO.Recordset.

Examples

A. Simple SQL-Query

These command  carries out a simple query which determines the number of addresses The determined number will be shown in a VBScript reference window.

VBScript
Sql = "SELECT number_of_addresses = COUNT(*) FROM address"
Set rs = Client.ExecuteSql(Sql, "Number of addresses determined")
MsgBox "In the database are " & CStr(rs.Fields("number_of_addresses").Value) &_
  " addresses available"