ExecuteScalar
The ExecuteScalar function returns the first column / row from a sql query.
Syntax :
ExecuteScalar(SQL)| Parameters | Description |
|---|---|
| SQL | The sql query required. |
Example :
iCount = ExecuteScalar(“SELECT 1,2”)- Would set icount = 1
The ExecuteScalar function returns the first column / row from a sql query.
ExecuteScalar(SQL)| Parameters | Description |
|---|---|
| SQL | The sql query required. |
iCount = ExecuteScalar(“SELECT 1,2”)