Gossamer Forum
Home : Products : Gossamer Links : Pre Sales :

Re: Some things to solve ...

Quote Reply
Re: Some things to solve ... In reply to
Elliot,

The duplicate ID number problem is unique to Links 2.0, and flat files. It's somewhat impossible with Links SQL, since the ID field is an auto-increment field, and as such is defined as _unique_.

Additions grab the next available ID number (that is what the ? is for), and insertions should also use a ? for the ID field, or risk getting an error message "Duplicate Key" or "Duplicate Field Value" or similar.

Using an auto-increment field is probably the best way to guarantee each record in a database has at least one UNIQUE identifier, and it satisfies the rules for normalizing tables.

http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Subject Author Views Date
Thread Some things to solve ... Robert 3893 Jul 26, 2000, 9:22 AM
Thread Re: Some things to solve ...
Stealth 3791 Jul 26, 2000, 9:32 AM
Thread Re: Some things to solve ...
pugdog 3789 Jul 26, 2000, 9:44 AM
Thread Re: Some things to solve ...
Stealth 3796 Jul 26, 2000, 10:19 AM
Thread Re: Some things to solve ...
pugdog 3792 Jul 26, 2000, 11:02 AM
Thread Re: Some things to solve ...
Robert 3777 Jul 26, 2000, 3:13 PM
Post Re: Some things to solve ...
Stealth 3838 Jul 26, 2000, 3:18 PM