Re: Variables in DB Query Builder
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
Re: Variables in DB Query Builder
--- Horst [EMAIL PROTECTED] wrote: Holá SQL-Professionals, I´m thinking, how to put a variable Part in the SQL-Message of the DB Query builder f.e. Select Landname, Landvorwahl from land_kz where Landname BETWEEN A% AND ¦ ORDER BY Landname ASC; How to put the variable instead of A% witch makes by the way, no sense. Thanks for many good ideas and don´t let me alone :-) Best regards Horst Hi Horst, The automated database queries don't currently provide for a method to place 'variables' inside the SQL query. 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 ## Hope this helped, Jan Schenkel. Quartam Reports for Revolution http://www.quartam.com = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.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
Variables in DB Query Builder
Holá SQL-Professionals, I´m thinking, how to put a variable Part in the SQL-Message of the DB Query builder f.e. Select Landname, Landvorwahl from land_kz where Landname BETWEEN A% AND ¦ ORDER BY Landname ASC; How to put the variable instead of A% witch makes by the way, no sense. Thanks for many good ideas and don´t let me alone :-) Best regards Horst -- View this message in context: http://www.nabble.com/Variables-in-DB-Query-Builder-tf2832420.html#a7907686 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