Member Avatar for dejanbl

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
  • 232 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by zortec
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.