Error while trying to add updated Fields in Clientdataset

Question

Error while trying to add updated Fields in Clientdataset

Asked 7 years, 8 months ago

Viewed 126 times

1

I am trying to update my Clientdataset’s Fields with the new variables of the bank, but I came across the following error:

Why this could be happening?

Join of the Tsqldataset:

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

After editing Fields the following error Occurs:

Your BD is postgresql?

– Sorack

2016/10/31 at 13:43
Yes, the application previously used the Firebird Database is now Postgresql

– R.Santos

2016/10/31 at 13:47
1

Everything indicates that it is a "Where" or "Join" where you compare a varchar with an integer. It can also be the type of parameter you entered into the component. Check if there is parameter, otherwise change remove the "Where" for verification, so you check the actual problem by deletion

– Sorack

2016/10/31 at 13:55
@Sorack I looked at the code and did not find an error in any "Where" or "Join" I will edit the question with the "Join" that is in my TSQLDataSet

– R.Santos

2016/10/31 at 15:42
I was able to access the Fields now, the error was in E.Usado = 0 that being a String would have to be E.Usado = '0'

– R.Santos

2016/10/31 at 15:47
Try to change the line "and E.Used = 0" to "and E.Used = '0'"

– Sorack

2016/10/31 at 15:47
Precisely. I will put this answer and thank you if you give me a +1 ^^

– Sorack

2016/10/31 at 15:48
Let’s go continue this discussion in chat.

– Sorack

2016/10/31 at 16:10

Show 3 more comments

1 answer

Browser other questions tagged delphi-7

You are not signed in. Login or sign up in order to post.

by Sorack • **27,430** points · Answer 1 · 2016-10-31T15:48:46+00:00

Everything indicates that it is a where or join where you compare a varchar with a inteiro. It can also be the type of parameter you entered in the component. Check if there is parameter, otherwise change the where for verification, thus you check the actual problem by deletion. Based on your SQL probably 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;