| **Navigation:**  [[introduction.htm|Language Reference]] > [[chapter runtime properties.htm|App C - PROP: Runtime Properties]] > Runtime VIEW and FILE Properties >====== PROP:MaxStatements ====== | [[prop logoutisolationlevel.htm|{{btn_prev_n.gif|Previous page}}]][[chapter runtime properties.htm|{{btn_home_n.gif|Return to chapter overview}}]][[prop profile.htm|{{btn_next_n.gif|Next page}}]] |
|  ||

Property of a FILE that allows you to find out how many statements can be active before a new connection to the database is raised. This property can also set the maximum number of statements before another connection is raised. This property is valid on all SQL file types except Oracle.

**PROP:MaxStatements** must be set after the file is open - OPEN(file) MaxStatements is always reset back to the default value of 150 when the file OPEN() is executed.

Example:

**OPEN(myFile)**\\ **mStatements = myFile{PROP:MaxStatements}   !return max allowable**

**myFile{PROP:MaxStatements} = mStatements   !set max allowable**