StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Application Framework - V1
»
Business Objects and Data Access (How do I?)
»
Primekey = two fields
Primekey = two fields
Post Reply
Like
0
Primekey = two fields
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Keith Chisarik
Keith Chisarik
posted 17 Years Ago
ANSWER
Topic Details
Share Topic
Group: StrataFrame Users
Posts: 939,
Visits: 40K
I have an existing DB2 database I have to work with, they have many tables where the "key" is the combination of one or more fields. How can I accommodate this design using SF?
The BO mapper lets me define multiple fields as primary keys via "Override Primary Key Specification", it then shows them as FIELD1,FIELD2. It is going to use the concatenation of these two fields as the primary key?
If not I should just be able to control the assignment of the two key fields manually right? Its more work but I did it before as a work around before I got my auto incrementing key fields working.
Thanks.
Keith Chisarik
Sigma Data Systems
Reply
Like
0
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
Primekey = two fields
Keith Chisarik
-
17 Years Ago
Also having problems with field names that have the # sign in them...
Keith Chisarik
-
17 Years Ago
I got things to work by manually removing the # sign from the field...
Keith Chisarik
-
17 Years Ago
On your first question, yes, the two fields are considered part of the...
StrataFrame Team
-
17 Years Ago
The updateable view using aliases for the "bad" field names worked,...
Keith Chisarik
-
17 Years Ago
Post Reply
Like
0
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search