Access and SQL server update

  • Thread starter Thread starter Bonzol
  • Start date Start date
B

Bonzol

Hey there,, I know when updating,, Access can be differnt from SQL
server

this works in access from a vb.net 1.1 prog


SQL = "Update Clients SET UnameID= '" + updatevalue + "' WHERE ID = " +

checkValue + ""


Can anyone just quickly tell me what i have to change for it to work in

SQL server 2005?


Thanx..
 
Bonzol,

As this is VB it would be nicer to use the concationation character &
instead of the + character, with option strict of the latter can give very
strange results.

Cor
 
It will work as is, but you are exposing yourself to SQL injection
attacks as well as errors when someone passes a value like o'malley.

Try and use parameterized SQL as much as possible
 
I call bullshit on your shit

just because you're a retard C# dude it doesn't mean that we all want
to add unnnecessary complexity to all of our apps

go and **** yourself; C# fag

-Aaron
 
and for the record.. THERE IS NO RAD IN C#

lick a monkey dick bitch

You'll be obsolete also when Microsoft renames VB to VB#


-Aaron
 
Back
Top