The .Change_Begin() method indicates that you are about to change the value of a field rule. Use .RULES_GET() to create the pointer.

Begin changes to tables current record.

Alpha Anywhere places a lock on a record when:

Creates a pointer to an open table and only contains the fields specified in the fieldList.

The following script is provides a simple example of how to use an index to determine whether a record exists, and to act accordingly. To start, we create an index based on lastname and firstname named "LF". The Order Expression for the index is alltrim(lastname) + "," + alltrim(firstname).

Many applications create a set with a parent table in a one-to-many relationship with a child table. Field Rules auto-numbering can assign unique ID numbers to the records in the parent table. The problem of numbering the child table records is cannot be solved with Field Rules, particularly if you want to reset the child record counter to 1 for each new parent record. For example, the solution might provide the following record numbers:

Active-Link tables allow you to work with data in SQL tables. An active-link table is a local Alpha Anywhere table that is dynamically populated with data from a remote SQL database. Any changes that you make to the local active-link table are immediately persisted (i.e. saved) to the remote database. This means that you can build Alpha Anywhere forms that update, insert and delete records in remote SQL tables. In addition, it means that you can use your knowledge of how to work with tables using Xbasic to manipulate data in remote SQL databases.

Start profiling for the thread.

One of the most common uses of the Application Server is displaying data from a database. This is quite easy to do now that you know how to include Xbasic in our pages. All that is needed is to use the Xbasic commands to open a table and retrieve data from it.

Lock database file for batched changes.