Environment versions
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only