I have a question about TFDQuery.
I have an SQL like this
"Select MyColumn, MyAnotherColumn, 0 as MyBooleanColumn...from MyTable"
Note "0 as MyBooleanColumn" expression.
That column is in a TDbGrid, with a checkbox.
When the user navigates the row and select the record -using the Space
bar in the grid- the checkbox is checked, using this
if fxSomeConditionPayments Then
MyQuery.FieldByname('MyBooleanColumn').AsInteger := 1
MyQuery.FieldByname('MyBooleanColumn').AsInteger := 0
The grid shows the checkbox according the condition. But I get the error
"Column not found" at "MyQuery.Post"
If the TFDQuery is a TClientDataset all this works ok.
Is there a way to use the TFDQuery as a TClientDataset -without using a
TClientDataSet-? Some property that means "give me the records and I
will have the records locally to manipulate them as I wish...