Hi Rainer, > an enquiry following up the nice explanation of a parameter query with > LIKE the other day. I use Base with MySQL 5.0 as backend. If I > understand correctly one can only use parameter-queries within the > Base-SQL-interpreter, right? I mean, if I press the execute-SQL > directly button, they don't work any more. (well, that is what I find > and I assume it's by design). This means something like SELECT * FROM > table WHERE field REGEX :param (REGEX rather than LIKE) is not > possible, right?
Right. > Would it be difficult to allow for that, Adding support for this to OOo's parser would probably not be too difficult, though we're always reluctant to add capabilities to parse highly back-end-specific SQL fragments. My preferred implementation would be to ask the database driver for the parameters in the statement, instead of letting Base's parser find them. Unfortunately, this would be less convenient for the user, since for instance the JDBC API does not allow to obtain parameter names (so in your example, you would not be asked for "param's value", but for some "value of the first parameter", which is somewhat ugly if you have more than one parameter). Anyway, there's no implementation for this, yet. Vote for issue 66559 if you want us to create one :) > or is there > another way of making regular expressions possible in parameter queries? No, sorry. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
