update

[Guest_imported]

Hello,

I have a vehicle reservation form, I want to know how to update this form where a user who has reserved a vehicle can change the times of the reservation. Then save this info. to the table. The 'time' is a text box.

Hope somebody help me out.
Joan

 

[Niv3k]

What language is the form that the user uses in? The SQL syntax could depend on the data type of the field, also.
Assuming it's a datetime field, and the value inside the textbox is '11:00:00 AM' and the table you are saving it to is called "Cars" and the name of the field is "TimeOfRental", a sample statement would be:

UPDATE Cars SET TimeOfRental='11:00:00 AM'

Kevin