On Thu, Feb 21, 2008 Olivier wrote: > Also I would need a way to prompt for a value to make the query: > Right now, my query looks like "select * from view where invoice_date = > 'blah'. I'd like blah to be prompted before the merge. >
modify the query so the value 'blah' is instead written :blah It is written without quotes. The colon tells OOo to prompt for the parameter value for blah. Note that this works when referring to a Base database. I don't know whether the same approach works with other SQL back ends.
