Specific Column

[pruebens]

How do I update a specific column to a specific value?

 

ie: I want to pass the word FALSE back to the database for a specific column

 

Thanks for helping out a n00b.

[wyrd]

Do you mean which value represents FALSE? It's either going to be -1, 0 or 1. One of those three numbers will represent TRUE as well.

 

Try all three, see what happens. :)

[pruebens]

No that's not what I meant (sorry).

 

I need to actually pass the word FALSE back to the database.

[Robby]

Is the fields' data type text (string) ?

[pruebens]

Yes

[wyrd]

If it's a text field then wouldn't it be as easy as putting in the text "FALSE"?

 

Or are you asking how to actually do it? IE: What's the code to update a database column?

[pruebens]

sorry I'm not explaining this very well :(

 

It's actually not a Text control but just text.

 

And I need to do something like this:

 

database.table.column = "FALSE"

 

But I'm such a n00b I can't figure out the code to do it.

[Derek Stone]

strSQL = "UPDATE myTable SET myTable.myField = 'FALSE' WHERE myTable.ID = 1"

Then create either a OleDbCommand object or a SqlCommand object, depending on your database type, associate it with a connection object and call ExecuteNonQuery().

[pruebens]

That did it. Thanks....you are very wise O ADO master :)

[Derek Stone]

ADO.NET thank you very much! ;)

[pruebens]

Ah yes.......how silly of me

 

/me bows to the wise one of ADO .NET