dnb
|
| Posted: 06/06/2002, 7:51 AM |
|
ASP 3.0 and the Beta 5 release on Win2K with SQL Server 2K:
This is wierd. I've been getting along just fine but suddenly a road block.
On one particular table that I want to update, the "edit" form only shows me
the "Add" button. Other places this has not been a problem. I used the
wizard to create a search/maint form pair. At this time, these are NOT
restricted, although I DO have security configured (I also tried "Full"
access with Restricted, to no avail). The design-time view shows the Add,
Submit and Delete buttons. Something is causing them to be suppressed at
runtime.
The difference I see is that the table being updated in this case has a
compound PK, where the others did not.
Because I display the two fields on the "maint" form I can see that when it
should "Add" (click "Add New" on the search form), the autonumber field is
omitted, and when it should "Edit" (click hyperlink on a record in the
search results grid), the autonumber field is passed to the maint form.
This has me stumped. Anyone with thoughts?
don
|
|
|
 |
dnb
|
| Posted: 06/06/2002, 8:14 AM |
|
I'm an idiot. I just finished hand-drawing a diagram (like the one you get
in V2.0, more or less) and after more careful checking, I HAD omitted one of
the PK columns in the "..." from Source/Parameters on the link for the edit
screen.
Now it's working like it should.
D'oh!
"dnb" <dnb@comcast.net> wrote in message
news:adnstd$n6$1@news.codecharge.com...
> ASP 3.0 and the Beta 5 release on Win2K with SQL Server 2K:
>
> This is wierd. I've been getting along just fine but suddenly a road
block.
> On one particular table that I want to update, the "edit" form only shows
me
> the "Add" button. Other places this has not been a problem. I used the
> wizard to create a search/maint form pair. At this time, these are NOT
> restricted, although I DO have security configured (I also tried "Full"
> access with Restricted, to no avail). The design-time view shows the Add,
> Submit and Delete buttons. Something is causing them to be suppressed at
> runtime.
>
> The difference I see is that the table being updated in this case has a
> compound PK, where the others did not.
>
> Because I display the two fields on the "maint" form I can see that when
it
> should "Add" (click "Add New" on the search form), the autonumber field is
> omitted, and when it should "Edit" (click hyperlink on a record in the
> search results grid), the autonumber field is passed to the maint form.
>
> This has me stumped. Anyone with thoughts?
>
> don
>
>
|
|
|
|
|
