Use the Read-Only SQL TextBox (SqlLabel) control to display text in the feature class form that is queried with an SQL statement. For example, you can display the area of the related polygon in a centroid feature class. You can also query and display data from different attributes and tables.
Test the SQL statement in the SQL Assistant.
Property |
Description |
System Category |
|
ClassName |
SqlLabel |
Name |
Specifies the name. For example, $SQLLABEL1. |
Specific Category |
|
AlignRight |
If True, aligns the value. Specifies whether the value is aligned to the right edge of the input box. |
FontName |
Selects a windows font including style and size. |
ForeColor |
Specifies the color of the text. |
Precision |
Specifies the precision of numeric values. |
Sql |
Defines SQL statements to query any information. |
UnAvailableValue |
If the SQL returns no result, this value is displayed. |
UseBuffer |
Specifies whether the buffer for the data can be switched off. If True, you can switch the buffer off the data. In some cases, it is necessary to see real data. Default = True. |
Notice the difference between Read-Only SQL TextBox and Editable SQL TextBox. Both controls allow you to query data, but in one case the result is displayed as a label, which means that it cannot be edited. In the other case, the result is displayed in a text box, and the value can be edited and saved (updated) in the database.