Operation not applicable Delphi Clientdataset [closed]
closed . This question needs details or to be clearer and is not currently accepting answers.
want to improve this question? add details and make it clearer what problem is being solved by editing this post .
Closed for 6 years .
improve this questionWhy am I getting the error Operation not applicable
when I open a TClientDataset
with data master-detail, but it's just a dataset
and a detail .
System Mode: DataSnap > on Qrypai/dspPai/Dspai server.
DatasetPai SQL "select * from orcamento_atendimento where orcamento_atendimento_id = :orcamento_atendimento_id"
qryFilho/dspFilho (ligação como pai pelo "mastersource = dsPai / masterfilds =
orcamento_atendimento_id")
Datasetfile
SQL "select o.orcamento_id,
o.sequencial,
o.orcamento_status_id,
s.descricao,
s.faturar,
o.orcamento_atendimento_id,
o.vendedor_id,
v.nome as vendedor,
o.data_orcamento,
o.data_validade,
o.observacoes
from orcamento o
left join orcamento_status s
on s.orcamento_status_id = o.orcamento_status_id
left join pessoa v
on v.pessoa_id = o.vendedor_id
where o.orcamento_atendimento_id = :orcamento_atendimento_id"
No client:
ClienteDataSet_Pai / remoteserver = dspOrcamento / providername = dspPai
clienteDataset_Filho / datasetfield = datasource_paidatasetFilho
When I make the links everything correct, but when I try to open or add the fields the error occurs.
2