Real or single

[Peter]

Hi, there

I'm creating a table for my Access database. Below is my code. I always got
a table I wanted no matter if I use "Single" or "Real" data type.

strSQL = "CREATE TABLE GeometryValues (" & _
"zNameID SmallInt NOT NULL PRIMARY KEY ," & _
"zValue Single NULL)"

or
strSQL = "CREATE TABLE GeometryValues (" & _
"zNameID SmallInt NOT NULL PRIMARY KEY ," & _
"zValue Real NULL)"

Dim cmd As New OleDbCommand(strSQL, Conn)

cmd.CommandType = CommandType.Text

cmd.ExecuteNonQuery()

note: conn is an open connection

My question is what data type should I choose, SqlDataType or OleDBType?

Thanks in advance

Peter

 

[MPF]

SqlDataType is for SQL Server only, OleDBType is for non-SQL Server data
sources.

 

[Peter]

Thanks