Edit query

[filipe26]

Hi i have a dbgrid with a Query datasource.I want to edit just the results of a query but when i do the command Tquery.edit; it tells me that the dataset is read only.
I ask what tQuery.edit does and how ro resolve the fact of edit just the results of a query.Thanks.

 

[Zathras]

Is your query accessing a single table or a join of two or more tables? Not all DBMS support update on a join.

 

[svanels]

The query has a property called Requestlive which by default is set to false. This returns a readonly dataset to your application.
Set the value to true and if the query is a select of a single table it will return an updatable dataset.

Regards

Steven van Els
SAvanEls@cq-link.sr

 

[filipe26]

Thanks it was request live that i had in false mode.