Hi list, Does anyone know if there is a limit in the length of the sql query when using revDataFromQuery ? According to what I found on the web, there doesn't seem to be any problem on mySQL side (default value is apparently 1 Mb), but I was more concerned by a possible buffer between LC and mySQL where the query could be truncated...
Furthermore, I am fully aware that very long queries are hard to maintain and might lead to slow execution... What I have in mind in some rather simpler stuff like : SELECT name FROM myDB WHERE name != 'John' AND name != 'Ted'... where the list of names can be quite long... Thanks, jbv _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
