Good morning friends,
I need to change the candidate key of several tables from one field to an expression of two fields. Example: Now the candidate key is field MY_ID, C, 20. After the change the candidate key will be MY_ID + STR(MY_INT_FLD,6).
Is there a better approach than to convert the Integer field to string using STR() function? Also, am I going to run into any problems with having candidate as an expression?
Thank you in advance for any suggestions.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
