js editor
Web development
File: ...\Samples\Solution\Db\Info.scx
This sample illustrates retrieving information about a table at run time.
Field Information
The AFIELDS(В ) function provides most of the information about table fields displayed in this sample. In addition to the information displayed in this sample, AFIELDS(В ) provides information about field and table validation expressions and messages, trigger expressions and messages, as well as long table names and table comments in the database.
Index Information
The TAG(В ) and KEY(В ) functions provide index information.
| В |  Copy Code |
|---|---|
lo = THISFORM.edtProperties
FOR i = 1 TO TAGCOUNT( )
IF !EMPTY(TAG(i)) && Checks for tags in the index
lo.Value = lo.Value + TAG(i) + " " + KEY(i)
ELSE
EXIT
ENDIF
ENDFOR | |