neoGsheet search using Where and "and"

#1 · September 18, 2021, 6:36 pm

And it show that you can use "and" so added it to:

neoGSheetsLoadAsTable "Container3" "[googleSheet]" "select C,D,E" ""

so giving me

neoGSheetsLoadAsTable "Container3" "[googleSheet]" "select ,C,D,E where A = CX2RA and B = 0" ""

The CX2RA will be changed to be [ComboBox1] and the 0 to [slide], when it works

Am I correct or is this function not available?

#2 · September 19, 2021, 12:23 am

neoGSheetsLoadAsTable "Container3" "[googleSheet]" "select ,C,D,E where A = CX2RA and B = 0" ""

1) I am assuming that the comma before the C is just a typo error.

2) If CX2RA is the actual value to be compared, then it should be wrapped in single quotes like 'CX2RA'

The CX2RA will be changed to be [ComboBox1] and the 0 to [slide], when it works

Please read my last post here ... https://visualneo.com/forum/topic/neogsheet-query-no-distingue-entre-minusculas-y-mayusculas ... for an anomaly with the neoGSheetsLoad command i.e. the third parameter can not contain a mixture of literal and [variable] specification ... so you have to compose the mixed query into a variable first (as shown in my post).

Hope this helps.

luishp and Darbdenral have reacted to this post.

neoGsheet search using Where and "and" - Forum