I'm using the code:
conexao.First;
while not conexao.Eof do
begin
if (conexao.FieldValues['complex'] = '02' and conexao.FieldValues['financ'] = '04') then
total24:= total24 + conexao.FieldValues['val_tot'];
conexao.Next;
end;
In this line if (conexao.FieldValues['complex'] = '02' and conexao.FieldValues['financ'] = '04') then I get the following error:
Incompatible types: 'string' and 'Boolean'
Why?
Generally, FieldValues['NOME_FIELD'] results is a Variant , without an appropriate typecast it can result in errors exactly the same as the one presented.
The correct way is to enter the name and type of the field, here is an example.
NOME_TABELA.FieldByName('NOME_FIELD').AsString = '02'
NOME_TABELA.FieldByName('NOME_FIELD').AsInteger = 02
NOME_TABELA.FieldByName('NOME_FIELD').AsBoolean = True
And so it goes.
The only solution is to separate the comparisons using parentheses:
if ((conexao.FieldValues['complex'] = '02') and (conexao.FieldValues['financ'] = '04')) then