default value for a timestamp field

07-24-2015, 05:55 PM

pschulz

Newcomer

Join Date: Jul 2015

Posts: 6

default value for a timestamp field

Hi there,

is there no way to have a timestampColumn within an Insert statement?
I could keep it out of course but sometimes, its needed.

This are 2 examples I've tried, but have still an error

Code:

Dim strTimestamp As String = String.Empty

mySQLCommand.Parameters.AddWithValue("@TimestampClm", SqlDbType.Timestamp)
mySQLCommand.Parameters("@TimestampClm").Value = strTimestamp

And even this one hasnt work

Code:

Dim myNull As SqlDateTime
myNull = SqlDateTime.Null

mySQLCommand.Parameters.AddWithValue("@TimestampClm", SqlDbType.Timestamp)
mySQLCommand.Parameters("@TimestampClm").Value = myNull

greetings and thanks

07-25-2015, 06:43 AM

PlausiblyDamp

Ultimate Contributor

Forum Leader
* Expert *

Join Date: Nov 2003

Location: Newport, Wales

Posts: 2,058

A column of type timestamp isn't meant to be inserted into, it exists as an autogenerated column type (https://technet.microsoft.com/en-us/...v=sql.80).aspx has more details).

Is there a reason why you need to insert a null / empty timestamp into a row?

__________________
Intellectuals solve problems; geniuses prevent them.
-- Albert Einstein

Posting Guidelines Forum Rules Use the code tags

07-25-2015, 01:58 PM

pschulz

Newcomer

Join Date: Jul 2015

Posts: 6

Hi PlausiblyDamp's, thanks for now.

Well, if nothing is inserted, than this column doesnt have any value, is empty. Or is there something I dont see?

I'm pleasure if this is normaly filled by autogenerated, but never saw it so.