[dba-SQLServer] XP adp and SQL2005

Thanks Mark,

While it didn't solve my problem, it pointed me to another solution 
base.  I am taking advantage of their free subscription to see if 
they have any answers.

Regards

David

At 23/12/2008, you wrote:

>Dave,
>
>I am by no means an expert with SQL Server...(add a grain of salt 
>here)...but I was able to recreate this...and found this link:
>
>http://www.experts-exchange.com/Microsoft/Applications/FoxPro/Q_22012455.html
>
>If I understand this...timestamp is just that...a timestamp the 
>system automatically generates and stores(kinda like an 
>autonumber...but for row versioning)...it is not for the user to add.
>
>Another link explaining some uses:
>http://www.sqlusa.com/articles2005/rowversion/
>
>Good luck,
>
>Hope this helps...
>
>Mark A. Matte
>
>
>
>
>
> > Date: Mon, 22 Dec 2008 15:30:28 +1300
> > To: accessd at databaseadvisors.com; dba-SQLServer at databaseadvisors.com
> > From: newsgrps at dalyn.co.nz
> > Subject: [dba-SQLServer] XP adp and SQL2005
> >
> > I have a view being used for a subform. It combines 4 tables but
> > only one has data which is changed. It is a 'many' table. All of
> > the tables have primary keys.
> >
> > The table being edited has a timestamp column created when the
> > database was upsized from Access XP to SQL2000. The database was
> > then scripted and created on SQL2005.
> >
> > When I try to add a record I get the following error:
> >
> > Cannot insert an explicit value into a timestamp column. Use INSERT
> > with a column list to exclude the timestamp column, or insert a DEFAULT.
> >
> > Because I am using a bound form I do not have the option of a column
> > list (I don't think). If I remove the timestamp field from the view
> > then I don't even get an option to add a record. With the timestamp
> > included I can add the data for a new record, but just can't save it.
> >
> > I am not sure what is meant in the error message by "Insert a
> > default". I tried adding a textbox to the form for the timestamp
> > field and put DEFAULT in the default property but this didn't work.
> >
> > Does anyone have any suggestions?
> >
> > Regards
> >
> > David Emerson
> > Dalyn Software Ltd
> > Wellington, New Zealand
> >
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> > 3
>_________________________________________________________________
>Send e-mail faster without improving your typing skills.
>http://windowslive.com/online/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_speed_122008
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com