SQLNetRetainDateFormats (Property)

Applies To:

Connection object, MetaDataConnection object

Description:

SQLNet Only. This property enables the retention of date formats specified by SQLNet.

Action:

Read-write, Boolean

Example:

This example creates a connection file and applies it to the current document:

Var myCon = Application.CreateConnection()
MyCon.Description = "This OCE configures the connection via ODBC, to a SQLServer 6.5 database named pluto."
MyCon.Api = bqApiSQLNet
MyCon.Database = bqDatabaseOracle71
MyCon.HostName ="PlutoORACLE"
MyCon. SQLNetRetainDateFormats =true
MyCon.SaveAs("d:\\OCEs\\PlutoORACLE.oce")

//Now use this connection in a data model
ActiveDocument.Sections["Query"].DataModel.Connection.Open
("d:\\OCEs\\PlutoORACLE.oce")