> I have this situation in an Active4D method (this example is straight > from the 4D Documentation)... > > QUERY([Invoice];[Invoice]Paid=False;*) > If($city#"") ` if a city name has been specified > QUERY([Invoice];[Invoice]Delivery_city=$city;*) > End if > If($zipcode#"") ` If a zip code has been specified > QUERY([Invoice];[Invoice]ZipCode=$zipcode;*) > End if > QUERY([Invoice]) ` Execution of query on the criteria > > I get an error on the final Query([Invoice]) :
Yeah, well the 4D documentation can't be trusted unfortunately. There needs to be a conjunction in the second two queries. Otherwise using query([sometable]) alone definitely works with a built query. Regards, Aparajita www.aparajitaworld.com "If you dare to fail, you are bound to succeed." - Sri Chinmoy | www.srichinmoy.org _______________________________________________ Active4D-dev mailing list [email protected] http://list.aparajitaworld.com/mailman/listinfo/active4d-dev Archives: http://vasudev.aparajitaworld.com/archive/active4d-dev/
