Error trying to add updated Fields in ClientDataSet

Question

Error trying to add updated Fields in ClientDataSet

Navigation

#1 by (2 votes)

1

I'm trying to update my ClientDataSet's Fields with the new bank variables, but I came across the following error:

Forwhatreasoncouldthisbehappening?

JointheTSQLDataSet:

selectE.*,S.SuprimentofromEstoqueE,SuprimentoSWhereS.Codigo=E.CodigoSuprimentoandE.Usado=0OrderbyS.Suprimento

Aftereditingthefieldsthefollowingerroroccurs:

delphi-7 tclientdataset

asked by anonymous 28.10.2016 / 13:22

1 answer

Is it possible to connect to PostgreSQL via ODBC in Delphi 7? Refresh RecyclerView from another Activity

score 2 · Accepted Answer

Everything indicates that it is a where or join where you compare a varchar with a inteiro . This can also be the type of parameter you entered in the component. Check for a parameter, otherwise change remove where for scanning, so you check the actual problem for deletion. Based on your SQL the error will no longer occur if you use the following:

select E.*,
       S.Suprimento
  from Estoque E,
       Suprimento S 
 Where S.Codigo = E.CodigoSuprimento
   and E.Usado = '0'
 Order by S.Suprimento desc;