mayeski
Posts: 4
|
Posted: 03/25/2004, 2:36 PM |
|
Have been trying this for several days without success. Using App Build I choose two tables for a test application. First page has your Search Record and results Grid, second page is the Add/Edit Record that is a single record selected from the grid. My problem is in selecting the correct and unique record AND getting all the columns I expect in the Add/Edit record. I can get one or the other!
It may be because there is no way to indicate a multi-part key in App Builder. The key for the table consists of columns we'll call A, B, and C. A is the link chosen in App Build, but just passing that column (or B or C) to the db won't get me the correct record. So I modified the Href Source in Link:A data Properties to be A AND B AND C and that gets me the correct record. But in doing this, something occurs that results in me getting only get those three columns, and not the other columns in the table, which I would get before I changed the Href Source. I don't get why they are related in this way.
If someone could point me to something in the documentation or tell me what I am misunderstanding I would be grateful.
|
|
|
DonB
|
Posted: 03/25/2004, 3:21 PM |
|
There is a trick to telling CCS about the rest of the PK. In the query
builder diagram, the PK column(s) are shown in bold text. If they are not
all indicated this way ,you can right-click and mark them as PK.
Just build things as if there was one column then go back and select the
other columns.
--
DonB
http://www.gotodon.com/ccbth
"mayeski" <mayeski@forum.codecharge> wrote in message
news:640635ef0cceaa@news.codecharge.com...
> Have been trying this for several days without success. Using App Build I
choose two tables for a test application. First page has your Search Record
and results Grid, second page is the Add/Edit Record that is a single record
selected from the grid. My problem is in selecting the correct and unique
record AND getting all the columns I expect in the Add/Edit record. I can
get one or the other!
>
> It may be because there is no way to indicate a multi-part key in App
Builder. The key for the table consists of columns we'll call A, B, and C. A
is the link chosen in App Build, but just passing that column (or B or C) to
the db won't get me the correct record. So I modified the Href Source in
Link:A data Properties to be A AND B AND C and that gets me the correct
record. But in doing this, something occurs that results in me getting only
get those three columns, and not the other columns in the table, which I
would get before I changed the Href Source. I don't get why they are related
in this way.
>
> If someone could point me to something in the documentation or tell me
what I am misunderstanding I would be grateful.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
mayeski
Posts: 4
|
Posted: 03/25/2004, 3:42 PM |
|
Thanks, DonB.
I'll try that - thanks for being there!
- Simon.
|
|
|
|