[dba-dev] Placeholder Characters in Parameter Queries
Under the OO-help Parameter Queries i found a special remark: Parameter queries with placeholders (*, _) or special characters (for example, ?) are not possible. This statement is not entirely true : Placeholders works but the user has to uses the SQL-placeholders like % an _ so the help should be is more correctly: like : Parameter queries with the OO placeholders (*, ?) are not possible. Only SQL-placeholders (%, _) can been used should I fill a issue not only to correct this help statement but also to correct the behavior that OO-placeholders are not transfered to SQL-placeholders ? In the same help section i found a cryptic phrase who i not understood and i suppose many other common users :-) if you formulate a parameter query and you save it with the variables, you can later create a query in which only the variables have to be replaced by the expressions that you want. OpenOffice.org asks for these variables in a dialog as soon as you open the query. Can someone explains me what thats means ? thanks Fernand - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Placeholder Characters in Parameter Queries II
Hello Fernand Vanrie schrieb: Under the OO-help Parameter Queries i found a special remark: snipp / In the same help section i found a cryptic phrase who i not understood and i suppose many other common users :-) if you formulate a parameter query and you save it with the variables, you can later create a query in which only the variables have to be replaced by the expressions that you want. OpenOffice.org asks for these variables in a dialog as soon as you open the query. Can someone explains me what thats means ? Can you explain more precise what do not understand? Regards Mechtilde -- Dipl. Ing. Mechtilde Stehmann ## Observer OpenOffice.org: lang/DE ## Freie Office-Suite für Linux, Mac, Windows, Solaris ## http://de.openoffice.org ## Meine Seite http://www.mechtilde.de ## PGP encryption welcome! Key-ID: 0x53B3892B - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Placeholder Characters in Parameter Queries
Hello Fernand Fernand Vanrie schrieb: Under the OO-help Parameter Queries i found a special remark: Parameter queries with placeholders (*, _) or special characters (for example, ?) are not possible. This statement is not entirely true : Placeholders works but the user has to uses the SQL-placeholders like % an _ so the help should be is more correctly: like : Parameter queries with the OO placeholders (*, ?) are not possible. Only SQL-placeholders (%, _) can been used should I fill a issue not only to correct this help statement but also to correct the behavior that OO-placeholders are not transfered to SQL-placeholders ? This would be very interesting, but I can't confirm it. Can you please create an example where you set a parameter query in which you can use a placeholder for selecting values from a column. Regards Mechtilde -- Dipl. Ing. Mechtilde Stehmann ## Observer OpenOffice.org: lang/DE ## Freie Office-Suite für Linux, Mac, Windows, Solaris ## http://de.openoffice.org ## Meine Seite http://www.mechtilde.de ## PGP encryption welcome! Key-ID: 0x53B3892B - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Placeholder Characters in Parameter Queries
Mechtilde wrote: Hello Fernand Fernand Vanrie schrieb: Under the OO-help Parameter Queries i found a special remark: Parameter queries with placeholders (*, _) or special characters (for example, ?) are not possible. This statement is not entirely true : Placeholders works but the user has to uses the SQL-placeholders like % an _ so the help should be is more correctly: like : Parameter queries with the OO placeholders (*, ?) are not possible. Only SQL-placeholders (%, _) can been used should I fill a issue not only to correct this help statement but also to correct the behavior that OO-placeholders are not transfered to SQL-placeholders ? This would be very interesting, but I can't confirm it. Can you please create an example where you set a parameter query in which you can use a placeholder for selecting values from a column. make a ODBC conection to (MS) SQL server based data base I make a simple query in design mode the like:Userinput must been written without spaces that resulys in a SQL statement: SELECT firma FROM Agentschappen.dbo.tbl_Klanten WHERE ( ( firma LIKE :UserInput ) ) when running the interface prompt for the Userinput and inputting a% results in the column content who started with a %a gives all results ended on a ect. greetz Fernand Regards Mechtilde - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Placeholder Characters in Parameter Queries
Fernand Vanrie wrote: if you formulate a parameter query and you save it with the variables, you can later create a query in which only the variables have to be replaced by the expressions that you want. OpenOffice.org asks for these variables in a dialog as soon as you open the query. Can someone explains me what thats means ? Hello Fernand, I suppose that what the help text is trying to explain is. Using the Base query designer to construct a query definition that includes variables. For instance create a new query with the designer that with the definition: - SELECT * FROM Table1 WHERE Table1.Name = :SearchName Save this query definition with the name Query1. Now if you open Query1 from the Base main window you will be prompted, in a dialog box, for the value to use in place of SearchName before the actual query is executed. It is worth noting that if you create a FORM or a REPORT based on Query1 then you will be prompted for this replacement value when the FORM or REPORT is opened also. Drew - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Placeholder Characters in Parameter Queries II
Fernand Vanrie wrote: when its means that you can later create a query means you can RUN a query then is understand the lot :-) I sent an earlier reply - but now that I see this I am left to ponder if the Help text author was not intending to explain what happens with the Query-in-Query feature. Base allows you to use an existing query definition as if it where a table inside of a new query definition. So - again assume you have a query Query1 that has a replacement parameter SearchName. Later you could create a new Query2 that includes Query1 as a record source ( as if it where a table ) and when Query2 is RUN it would prompt for the SearchName parameter also. Drew - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Placeholder Characters in Parameter Queries II
Mechtilde wrote: Hello Fernand Vanrie schrieb: Under the OO-help Parameter Queries i found a special remark: snipp / In the same help section i found a cryptic phrase who i not understood and i suppose many other common users :-) if you formulate a parameter query and you save it with the variables, you can later create a query in which only the variables have to be replaced by the expressions that you want. OpenOffice.org asks for these variables in a dialog as soon as you open the query. Can someone explains me what thats means ? Can you explain more precise what do not understand? when its means that you can later create a query means you can RUN a query then is understand the lot :-) Regards Mechtilde - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]