Syntax needed to prompt the user to enter criteria when running a query on an Oracle database
Active Query Builder allows to use parameters starting from colon, i.e.
"WHERE Field = :ParamName" This notation is natively supported by Oracle OLE DB providers, so you shouldn't have problems with it.
For other servers we allow usage of unnamed parameters ("WHERE Field = ?") and named parameters starting with @ for MS SQL Server.
2 days, 13 hours since original post