Taris
Posts: 18
|
Posted: 10/07/2005, 4:51 AM |
|
[At first english is not my native language so please excuse if the style of writing is not the best]
So in several Projects, I use MySQL Tables, that have values that are only unique in a special kombination. For example lastname and the firstname, so I can insert Multible "Smiths" John Smith, Frank Smith etc, etc, just second Frank Smith ist not allowed ....
in MySQL it is something like this:
ALTER TABLE `trainer` ADD UNIQUE `index_names` ( `t_lastname` , `t_firstname` )
Codecharge can only cope with a single Unique field, so I habe to programm a "workaround" in the event BEFORE EXECUTE INSERT.
I mean it works, but it would be much more convinient if CCS could do that as a "native" functionality.
|
|
|
|