Each field on a grid or dialog component has a Column Properties > Security level property. This property contains an integer number with a value of 0 or higher. There is no upper limit to its value.

To resize field lengths in a table to fit its data:

By default, a web page will not display files located outside of the webroot folder structure. The advantage of this restriction is that it prevents unauthorized users from changing or damaging your data. But when you want to selectively use data outside of the webroot, there are two techniques for overcoming this limitation.

Selecting fields, refreshing the fields list, adding and deleting fields, moving fields, and using the editable feature.

This topic describes a general technique for tracking when fields in different tables are modified. The technique uses:

The Invoice form contains the btnEditItems0 ( Zoom ... ) button. The Xbasic code run by the button's OnPush event creates and sets the value of the global variable varInvoice_Number, then displays the Items form (from the AlphaSports sample database). The result is that the global variable varInvoice_Number only exists when the Items form is called by the Invoice form.

Procedure for adding fields to a list dialog box.

In this white paper, you will learn how to move a Microsoft Access desktop application to the Web with Alpha Five. You'll see how easy it can be, and when you're done you'll understand the process well enough to undertake it yourself.

Default Behavior, Using "Nowrap", and Using a TextBox.

The Set Variable(s) to Field Statistics action retrieves statistical information (such as count, minimum, or average) for a specific field on a form.