Please enable JavaScript to view this site.

Navigation: Using ASPRunner.NET > Choose pages screen

Key columns

Scroll Prev Next More

 

The Key column is a table field that lets you query and modify each record individually, without altering other records in the same table. The values of a key column are unique.

 

You can specify any number of the columns that form a key. In general, one key column is sufficient, as it forms the primary key.

 

The key column is required for the tables that need the Edit, Delete or View functionality, work with images, or Print/Export the selected records. Do not remove the key columns from the query.

step5-2

 

To change the selected key columns, proceed to the Choose pages screen and click Edit under the Selected key columns.

step5-1

 

The best option is to use an auto-incremented field as a primary key field so that the database generates a unique key value every time you add a new record.

 

With MS Access, the best choice for a key column is an AutoNumber field.

key_column_access

 

In Microsoft SQL Server use an INT IDENTITY field, in MySQL use an INT AUTO_INCREMENT field.

See also:

Choose pages screen

List page settings / Click actions

Add/Edit page settings

CAPTCHA on Add/Edit pages

Update selected

Export/Import pages

Printer-friendly/PDF view settings

Geocoding