Phil
|
| Posted: 06/20/2003, 12:16 PM |
|
I am learning CCS, and am able to create functioning pages using the app
builder with an MS Access database. I switched to a SQL2000 Server
database, and followed the exact same steps using the app builder. But when
I click the record update link (ID #) on the list page, I get a "new record"
page with the "add" button, instead of the "update record" page. My
connection is oledb, with the "sa" login for the sql2k database.
I am stumped.
|
|
|
 |
DonB
|
| Posted: 06/20/2003, 12:48 PM |
|
If you are trying to edit a record, but it always comes up with a new record
instead. This is because you have not passed the primary key in to the
record form, so it assumes you want to add a new record.
You probably have the "update" link functioning without a parameter, or the
parameter is trying to obtain it's value from the wrong place and comeing up
empty. Click the "..." on the href source. See that it has link parameters
that match the primary key and that the source is correct - probably should
be "URL". Hover the mouse over the link and see if there is something in
the status bar like "?ID=123" or only "?ID=". The latter is likely what you
will see, so you are not passing a value in the parameter when you click the
link.
DonB
"Phil" <padams@nascar.com> wrote in message
news:bcvmhp$k1b$1@news.codecharge.com...
> I am learning CCS, and am able to create functioning pages using the app
> builder with an MS Access database. I switched to a SQL2000 Server
> database, and followed the exact same steps using the app builder. But
when
> I click the record update link (ID #) on the list page, I get a "new
record"
> page with the "add" button, instead of the "update record" page. My
> connection is oledb, with the "sa" login for the sql2k database.
>
> I am stumped.
>
>
|
|
|
|
Phil
|
| Posted: 06/20/2003, 1:24 PM |
|
Thanks for this tips, I found the problem...yes, status bar showed "?ID=".
So I started checking the properties for that column. In my SQL2k table,
the primary key is "ID". But CCS has modified that to "tblCompany_ID" in
the control source. Next I checked the Href Source, and noticed that
parameter source was "ID" with name "ID". so I deleted the parameter, and
added a new one, picking "tblCompany_ID" as source. CCS added the name
"tblCompany_ID". Still didn't work. Went back to the Href Source
parameter, and left the source as "tblCompany_ID", but changed the "name" to
"ID". This did the trick.
So apparently, CCS is taking the liberty to modify that primary key name,
but goofed up the parameter.
"DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
news:bcvoel$o0f$1@news.codecharge.com...
> If you are trying to edit a record, but it always comes up with a new
record
> instead. This is because you have not passed the primary key in to the
> record form, so it assumes you want to add a new record.
>
> You probably have the "update" link functioning without a parameter, or
the
> parameter is trying to obtain it's value from the wrong place and comeing
up
> empty. Click the "..." on the href source. See that it has link
parameters
> that match the primary key and that the source is correct - probably
should
> be "URL". Hover the mouse over the link and see if there is something in
> the status bar like "?ID=123" or only "?ID=". The latter is likely what
you
> will see, so you are not passing a value in the parameter when you click
the
> link.
>
> DonB
>
>
> "Phil" <padams@nascar.com> wrote in message
>news:bcvmhp$k1b$1@news.codecharge.com...
> > I am learning CCS, and am able to create functioning pages using the app
> > builder with an MS Access database. I switched to a SQL2000 Server
> > database, and followed the exact same steps using the app builder. But
> when
> > I click the record update link (ID #) on the list page, I get a "new
> record"
> > page with the "add" button, instead of the "update record" page. My
> > connection is oledb, with the "sa" login for the sql2k database.
> >
> > I am stumped.
> >
> >
>
>
|
|
|
|
|
