0

Hi,

i need some help, i need to delete some data in DBF file, and i have this code... but when i execute it .. nothing happends?

Dim connectionString As String
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=D:\Documents and Settings\dmarinkovic\Desktop\Data1\FP550_EO022450;Extended Properties=dBase IV"

Dim dBaseConnection As New System.Data.OleDb.OleDbConnection(connectionString)
Dim cmmd As New System.Data.OleDb.OleDbCommand("PACK Articles", dBaseConnection)

dBaseConnection.Open()

Dim dBaseCommand As New System.Data.OleDb.OleDbCommand("DELETE FROM Articles where PLU<>1", dBaseConnection)

dBaseConnection.Close()

2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by zortec
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.