In usinhg"Execute Query" how do i deal with queries with a lot of sub queries? ( Query that contains a lot of sub queries)

In usinhg"Execute Query" how do i deal with queries with a lot of sub queries? ( Query that contains a lot of sub queries)

Try to put it inside a For each. It worked for me.

Hi Sir Pablo, sorry for the newbie question. Is it ‘For Each Row’ or ‘For Each’?
image

I’ve been trying to use execute query on this query statement but the problem is it returns the incorrect number of items:

Hi @paolomondelo, don’t be sorry! :slight_smile:

Follow this post, maybe help you Execute NonQuery issue - quotes - #2 by indra

EDIT: Damn, the post is about NON-Querys… but also try it :slight_smile:
Bests,
Pablo

Just a question for Execute NonQuery issue - quotes - #2 by indra , is ‘datableSolapes’ a var type = DataTable ?

image

Thank you Pablo!:slight_smile: This is a tough cookie to solve. I’ve been trying to crack this query statement issue that i have been encountering. Will update you if I was able solve it or if i have questions :slight_smile:

@paolomondelo Oh great!!

Yes its DT type. But you solve it, so gratz!

Bests,
Pablo