Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Insert without nulls from NET
Message
De
25/08/2009 14:00:12
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01414410
Message ID:
01420520
Vues:
50
>Hi Don,
>
>Can you execute SELECT SET("NULL") over the connection (you might need to add a dummy table)? Does it report ON or OFF?

Thanks Chris -
This code:
Public Function TestNull() As String
		Dim SQL As String = "SELECT SET('NULL') from TIP"
		Dim oConn As New OleDbConnection(ConfigurationManager.ConnectionStrings("TIPWebEdits").ConnectionString)
		Dim oCommand As New OleDbCommand(SQL, oConn)
		Dim RetVal As String
		oConn.Open()
		RetVal = oCommand.ExecuteScalar
		oConn.Close()
		Return RetVal

	End Function
reports ON. This is my connection string.
<add name="TIPWebEdits" connectionString="Provider=VFPOLEDB.1;Data Source=|DataDirectory|\Tip_WebEdits\tip_webedits.dbc;NULL=NO"
		 providerName="System.Data.OleDb" />
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform