update tablename set a=1, b=2 where m=3
should do it. Remember you must enclose text fields in single quotes:
update ch set picture = 'ch1.jpg'
using params with suitable types would sort out the quoting issues
'automagically'.
Dave
tony_bat wrote:
I am new to ado. I have been writing sql
Duh I was using double quotes. Some times you can't see the forest for the
trees.
Thanks Tony
Dave Sellers [EMAIL PROTECTED] wrote:
update tablename set a=1, b=2 where m=3
should do it. Remember you must enclose text fields in single quotes:
update ch set picture = 'ch1.jpg'
using
2 matches
Mail list logo