Variables in DB Query Builder

[Horst]

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.