|
evansforsyth -> Updating with a Custom Query (6/17/2002 2:45:06)
|
Lacking some basic knowledge!
The following custom query won't update the database:
UPDATE Results SET Bathrooms '::Bathrooms::'
WHERE (ID = ::ID::)
1. In a custom query '::Bathrooms::' would use a text variable to update a text field. Right?
Suppose it was a number variable and a number field, then ::bathrooms:: would work. Right?
2. Does every field name have to be updated--or can just the fields with changes be updated.
In this case there are a dozen or so fields, but only the Bathroom field is being updated.
Thanks for helping out a rookie!
Evans
|
|
|
|
