update SQL table using MSflexgrid

Hi

I want to update a table using a msflexgrid - is it better to use an
update stmt or is there a better way???

plz help


:p :p

anyone?? is it just a simple update or would I need to do more?
:p

Retrieve the values from the grid, put them into an update statement and execute the update from a command object.

Quote:

---

Originally posted by KMcKenzie
Retrieve the values from the grid, put them into an update statement and execute the update from a command object.

---

I did not ask how to do it :D , I asked whether it would be better
to use an update stmt or is there a better way of accomplishing
this??? ;)

And I was telling you that was the best way to do it. :wave: Otherwise I would have offered and alternative :D

It's better to use the connection object's EXECUTE method. This of course assuming you're using ADO. :)