UPDATE command - Xtreme Visual Basic Talk

06-12-2006, 11:24 AM

dobbs

Junior Contributor

Join Date: Apr 2003

Posts: 220

UPDATE command

I am using the following code to update my Access database, but it is not updating the values. I do not get any errors and it steps through the code fine. Can anyone see a syntax error that I might have?

Code:

        Dim connDriver As String = "Provider=Microsoft.Jet.OLEDB.4.0;"
        Dim connFile As String = "Data Source=" & sPGDBPath & ";"
        Dim sSQL As String
        Dim i As Integer

        dataTable = New Data.OleDb.OleDbConnection(connDriver & connFile)
        dataTable.Open()

        For i = 0 To lstSelected.Items.Count - 1

            sSQL = "UPDATE subinfo SET rules = '" & ruleStr & "'"

            dataCmd = New Data.OleDb.OleDbCommand(sSQL, dataTable)
            dataCmd.ExecuteNonQuery()

        Next

        dataTable.Close()

Thanks!

06-12-2006, 01:41 PM

PrOpHeT

Hopelessly confused...

* Expert *

Join Date: Mar 2001

Location: Tyler, Tx.

Posts: 3,054

Only that without a where clause on the update, you would be setting every field in subinfo.rules to rulestr lstSelected.Items.Count - 1 times. I do not see where the lstSelected loop is even relevant to the query?

__________________
When you earnestly believe you can compensate for a lack of skill by doubling your efforts, there's no end to what you can't do ;)

For the love of Gold...

Posting Rules

You may not post new threads

You may not post replies

You may not post attachments

You may not edit your posts

BB code is On

Smilies are On

[IMG] code is Off

HTML code is Off

Forum Rules