update SQL table using MSflexgrid

[holly]

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

[holly]

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

[KMcKenzie]

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

[holly]

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 , I asked whether it would be better
to use an update stmt or is there a better way of accomplishing
this???

[KMcKenzie]

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

[mendhak]

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