On Sep 30, 2011, at 12:45 PM, Doug Hall wrote: > 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]) : > > A ";" was expected. (The right parenthesis of Query([Invoice]) is in > red, so that's where it's expecting it.) > > Can't Active4D close and execute a complex query such as this, the > same way 4D does?
Yes, used it all the time, most often in a qry_many.a4d file where there is a search. I don't think you mean you used this example DIRECTLY (no zip code in invoice table), but something similar. I'd say one of your if statements completes the query and you missed it. (missing a *) Steve _______________________________________________ Active4D-dev mailing list [email protected] http://list.aparajitaworld.com/mailman/listinfo/active4d-dev Archives: http://vasudev.aparajitaworld.com/archive/active4d-dev/
