Update Query SQL Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am getting stuck on the SQL code to do this.

What I want to do is Prompt a user for input a value for "City" on table
"Shipping" and update the field City on table shipping to this new value.

there is an ID feild that will always be set to 1.

any help?
 
"Bombay"wrote:
I am getting stuck on the SQL code to do this.

What I want to do is Prompt a user for input a value for "City" on table
"Shipping" and update the field City on table shipping to this new value.

there is an ID feild that will always be set to 1.

any help?
Click to expand...

Not enough details, but in a general sense
I think you could try something like

UPDATE
TABLE Shipping
SET City = [Enter New City]
WHERE
ID = 1;

Something like this should really done
through a form that asks the user, then
you can test in code for valid entry (or
user chooses city from a combo box
so you control what can be entered)...

then, you create the SQL in code using
form value, then execute update query...

good luck,

gary
 
Back
Top