The fastest easiest way to get it right.
You Are Always ConnectedManual SQL

The SKEY Column

Every table in an Andromeda database contains a column called "skey", which contains a unique integer value.

The skey value is very handy in user interface programming where you often are working with only one row. If you make it a practice to always retrieve this value, it is very useful as a unique identifier for HTML elements. The skey value also makes it very easy to code manual updates and deletes, and it also makes it easier to use the SQLX_Insert, SQLX_Update and SQLX_Delete functions.

The SKEY Column is not a primary key and cannot be used as a foreign key in other tables. A row's skey value should never be saved in other tables as a reference to the original row -- always use your own primary key instead.
You Are Always ConnectedManual SQL

User Comments

There are no user comments yet on this page.

Add A Comment

Comments will not appear until after they are moderated. Comments are usually moderated within a few hours on weekdays, but may take longer on weekends and holidays.

Name or nickname: (This will appear with your comment)


Email (this will never be displayed)


Enter your comment here. Use [b] and [/b] for bold, [i] and [/i] for italic, and [pre] and [/pre] for code samples. All literal HTML and PHP that you enter will be escaped out and displayed as you enter it.


Home |  Documentation |  Download |  Credits |  Contact |  Login
Andromeda © Copyright 2004-2010, Licensed under the GPL Version 2