Contents - Index

BDE SQL

Advanced Network Monitor allows you to connect to BDE server and execute a user query. Depending on the query result and conditions you specified the program marks the server as "Success" or "Error".

You need to enter the following parameters:
  • BDE Alias - Enter the BDE alias of the database you want to connect to.
  • User name - credentials required to access the database.
  • Password - credentials required to access the database.
  • Script source - enter you SQL query in this filed.
  • Also you need enter the conditions depending on the server is marked as "Success" or "Error":
  • First row in first record must be - Specify a comparison condition: "Equal to", "Less than", "Greater than", "NULL", "Not NULL".
  • to the following value - Enter a value the first row in the first record of the SQL query result will be compare with.

    Advanced Network Monitor tries to connect to the BDE Server and execute the specified SQL query (the SELECT command). If the query is executed successfully the program compares the first row in the first record of the SQL query result with the value you specified in the "to the following value" option. If the SQL query result meets the conditions the server is marked as "Success", otherwise as "Error".