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 statements for years. I can
>retrieve info now using ado query. My problem is I can not format a
>update statement that works either using adoquery or adocommand. Would
>someone please send me a simple sql statement that works please no
>parms just simple Update table a set field b = x, field c = y, field d
>= z where field m = 1.
>
>example of code Update ch set picture = ch1.jpg
>gives error too few parameters. expected 1
>
>example of code Update ch set picture = "ch1.jpg"
>gives error Invalid bracketing of name {ch1.jpg]
>
>using d7 professional
>xp sp2
>
>Thanks in advance
>Tony
>
>
>
>
>
>
>-----------------------------------------------------
>Home page: http://groups.yahoo.com/group/delphi-en/
>To unsubscribe: [EMAIL PROTECTED]
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
-----------------------------------------------------
Home page: http://groups.yahoo.com/group/delphi-en/
To unsubscribe: [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/delphi-en/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
