topic Re: Script error in App Development

Script error

vandrecarlos — Sat, 16 Nov 2024 21:14:34 GMT

Hi guys!

I'm trying to use a new table on my app, but during the execution of the task to load the data, I'm receiving the following error:

Someone here knows what this error means? "-129 = "

Thanks for the help!

Re: Script error

Marcos_rv — Thu, 14 Mar 2019 14:09:10 GMT

Hi how are you?

Could you tell us how are you relating the tables?

I see that you have a LEFT JOIN statement but you do not clarify which table you are doing the LEFT, it usually points to the last added table (the table above)
I recommend adding left join (your_table), now I also see that you do not have fields in common in those 2 tables that you show us, this will make you have as a result a Cartesian. I ask you if you can review that.

Regards!!!!

Re: Script error

vandrecarlos — Thu, 14 Mar 2019 15:24:34 GMT

Marcos, I'm good. Thanks!

My commom field is the [TXJCD] and the concatenated one ([ZE_CHARUF] & ' ' & [ZE_TXJCD].

I cant match fields with a concatenation?

Thanks!

Re: Script error

Marcos_rv — Thu, 14 Mar 2019 15:38:39 GMT

If you are going to join them through the address, what you would have to do minimum have the same field name in the 2 tables, notice that when you add the sentence "AS", in both tables you are adding different names, in a "Client emissor .... "and in the other" Client fiscal domicile ... ".

use the same name in both tables so that the JOIN is done correctly.

Regards!!!!

Re: Script error

vandrecarlos — Thu, 14 Mar 2019 17:04:21 GMT

Thank you so much, Marcos!
Works perfectly!