Very Computer

My True DBGrid is bounded with a complex SQL.  I have 3 columns filled with
 information from that SQL and I add one column that will be used by the
user to insert information.  I want to update only the last column.

Right now, I could not update any column even if the allowupdate property
is set to true.

How can I do that?

--
Nathalie Turgeon

Sounds like the problem is that your SQL query is not updateable.

In complex SQL statements all of the Join fields must also be index fields
for the Query to be updateable.

Try building the same SQL statement in Access and see if you can update any
field!
If not add indexes on all the joined fields and try again.

Decio.