Henryk
|
| Posted: 02/17/2004, 8:34 AM |
|
Accidentally posted this in the wrong forum, reposting it here because I am using cc studio.
I created a search form and record editing form using the application buider. When I click on the link for a record from the search page, rather than opening that record it appears to open a blank/new record. I am guessing I missed something pretty obvious, but where would I go to fix it so that it pulls that record up for editing when you click on the link to the record from the search page. I tried building it twice in application builder, the second time I was very conscientous to make sure anything that implied being able to edit records was checked. Thank you!
Henryk
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 02/17/2004, 11:33 PM |
|
Hneryk,
What is the URL when you click on that link? Does the URL contain the key name and record id?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
HenrykH
|
| Posted: 02/24/2004, 8:17 AM |
|
I fixed it, I included the prim key and somehow that resolved it. I can not remember, but I am inclined to think it did have the info in the url, but I can not say for sure. Thanks :)
Henryk
|
|
|
|
DonB
|
| Posted: 02/24/2004, 8:42 AM |
|
CCS tries to figure out what to do based on the Data Source parameters you
define and by inspecting the table/query to find out what the database
defines as the Primary Key.
CCS automatically sets the form into "Insert" mode when the Primary Key is
not provided as a query parameter (meaning you haven't got something like
"?xyz=123" in the URL (where "xyz" is the query parameter associated with
the primary key). If the table in the database has no primary key defined
when the form is created, then the form will assume Insert mode because it
can't determine what key to use to retrieve a record for updating.
You can find out whether the primary key is present by looking at the Data
Source properties. On there, there is a button to "Build Query". Click
that button and look at the table(s) displayed. The primary key field(s)
appear bolded. If none are bolded, then there is no primary key defined (or
you created it after the form was created). You can right-click the field
to see a popup menu. Check the "Primary Key" in the menu and republish the
form..
--
DonB
http://www.gotodon.com/ccbth
"HenrykH" <HenrykH@forum.codecharge> wrote in message
news:2403b7934a849b@news.codecharge.com...
> I fixed it, I included the prim key and somehow that resolved it. I can
not remember, but I am inclined to think it did have the info in the url,
but I can not say for sure. Thanks :)
>
> Henryk
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
