is enough to cause an error[/unquote]
He is going to RecordForm with no ID on the URL, so the form goes for
InsertMode!
I think he just has to set the RecordForm Allow Insert/Allow Update/Allow
Delete to NO.
The thing I am wondering about is how is he selecting the record?
I think he forgot to mention there actually is a Grid first -> RecordForm.
Otherwise he has to built a RecordForm with Insert/Update/Delete Allowed =
No,
have an input textbox and some custom select a record based on the inputed
ID.
Walter
"defiantclass1" <
defiantclass1@forum.codecharge> schreef in bericht
news:643a2dfdd9dc24@news.codecharge.com...
> Hello,
>
> I am creating a page from a table in SQL Server that is an Identity field
> that
> increments by 1 with each new record.
>
> I just want to be able to view this field on my page. I do not intend to
> try
> and enter the next number in the field manually. But it seems that just
> having
> that field present in the form is enough to cause an error when adding a
> new
> record. The error I get is:
>
> Cannot insert explicit value for identity column in table 'TableName' when
> IDENTITY_INSERT is set to OFF.
>
> I understand why it doesn't want to do it, but it doesn't understand that
> I
> don't really want to add that value, just see it as it does it by itself.
> (View
> Only)
>
> Any ideas? Thanks!
> ---------------------------------------
> Sent from YesSoftware forum
>
http://forums.codecharge.com/
>
