NeoDBpro allows you to open an unlimited number of database files and tables. Each database and table automatically create some unique global variables that contain important status information that you can access from VisualNEO for Windows.


As with field variables, each status variable is a combination of the Database ID, a period (.), the Table Name, a period (.) and the field name. Since NeoDBpro allows you to open multiple databases and tables at the same time, this method makes it unlikely that any two databases will have conflicting status variable names.


Status variables may be inserted wherever normal VisualNEO for Windows variables are accepted. For example, after calling dbpOpenTable, we can display an alert box to report the total number of records the table contains using the $RecCount variable:


dbpOpenTable "MyDB" "Clients" ""

AlertBox "Report" "The Clients table contains [MyDB.Clients.$RecCount] records."


You could also display the number of the current record on screen by adding the [MyDB.Clients.$RecNum] variable to a VisualNEO for Windows Text object. For example:



Status variables are read-only, meaning that they can be displayed but not modified using the SetVar or any other action commands. Instead use NeoDBpro actions like dbpNext, dbpPrev, etc. to display a different record.


Below is a list of status variables created for automatically by NeoDBpro. Replace "ID" with your Database ID and "Table" with the name of your table.


[ID.Table.$RecNum]

This is the current active record's position from the beginning of the file based on the current sort/query.

[ID.Table.$RecCount]

If a query is active, the result reflects the number of found records. When no query is active, the result reflects the total number of records in the database.

[ID.Table.$State]

This is the current state of the table. Possible values include "Browse", "Edit", etc.

[ID.$Status]

Contains the connection status of the database. This can be either "Connected" or "Not Connected".