Versions des environnements
Network:
Windows 2000 Server
Hi Daniel,
Thats happen because you have fields which does not accept .null. values
Try next
Command.CommandText = "SET NULL OFF"
Command.ExecuteNonQuery()
Command.CommandText = "insert into backup (id,descr) values (2,'danny');"
Command.ExecuteNonQuery()
It works
Denis
>hello i've a problem. i've this code:
>
>Public conecion As New OleDbConnection
>Public command As New OleDbCommand
>
> Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
>
> conecion.ConnectionString = "data source=d:\sog-net\principal\data\general.dbc ; provider=vfpoledb.1"
> conecion.Open()
> command.Connection = conecion
> command.CommandText = "insert into backup (id,descr) values (2,'danny');"
> command.ExecuteNonQuery()
> conecion.Close()
>
>end sub
>
>but i tr execute that show this problem :
>
>An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll
>
>this message show in command.executenonquery()
>
>how i make to resolve that problem, thak'u
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement