# RECORDCOUNT

This Keyword returns a *\<numeric>*, the number of records returned by the last "select" query.

{% hint style="warning" %}
The following Actions can affect the value of this Keyword:
{% endhint %}

| **Action**                                                                                                                          | Note                                                                                                                                          |
| ----------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------- |
| [SELECT](https://doc.sysdevmobile.com/kalipso5/developing/form/actions/actions-description/group-database/select)                   | The Keyword assumes the number of records returned by the query.                                                                              |
| [SQL Advanced](https://doc.sysdevmobile.com/kalipso5/developing/form/actions/actions-description/group-database/sql-advanced)       | If the executed query is a "select", the Keyword assumes the number of records returned by the query. Otherwise, the Keyword assumes value 0. |
| [Exec. Procedure](https://doc.sysdevmobile.com/kalipso5/developing/form/actions/actions-description/group-database/exec.-procedure) | If a "select" is performed inside the procedure, the Keyword assumes the number of records returned by the first one.                         |

{% hint style="info" %}
The "[Lookup](https://doc.sysdevmobile.com/kalipso5/developing/form/expressions/functions/functions-descriptions/conditional-functions/lookup)" Function doesn't affect this Keyword.
{% endhint %}