CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

 Editing Records

Print topic Send  topic

Author Message
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
View profile  Send private message
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/
>


Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.