Mark A Matte
markamatte at hotmail.com
Mon Dec 22 09:12:25 CST 2008
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