Hola Jan, thanks for answering!
You wrote: For now the easiest way to achieve dynamic queries is to save a template query somewhere, and fill in the dynamic parts, then update the SQL of the query using the undocumented command "'revSetSQLOfQuery <name of the query>,<sql statement>". An example : ## on mouseUp put "123456" into tCustomerID # or some field data put "SELECT * FROM orders WHERE customerid='" & \ tCustomerID & "'" into tSQLStatement revSetSQLOfQuery "orders",tSQLStatement end mouseUp ## ------------------------------------------------- Well, but what does this do? I donĀ“t understand that. What to do with revSetSQLOfQuery "orders",tSQLStatement best regards Horst -- View this message in context: http://www.nabble.com/Variables-in-DB-Query-Builder-tf2832420.html#a7948998 Sent from the Revolution - User mailing list archive at Nabble.com. _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution