Hello, I was going to answer one of those easy questions on the forum: http://user.services.openoffice.org/en/forum/viewtopic.php?f=13&t=7070
Help on query desing says: > You must place the variable between square brackets (=[x]) to create a query > with variable parameters. Alternatively, you can use an equal sign followed > by a colon (=:x). When the query is executed, the program will display a > dialog asking you for the expression to which the variable x should be > assigned. This is what I tried so far in parsed SQL mode: SELECT * FROM "Table" WHERE "Name" LIKE Concat( '%', Concat( [X],'%' ) ) SELECT * FROM "Table" WHERE "Name" =[X] obviously this syntax does not work at all. SELECT * FROM "Table" WHERE "Name" LIKE Concat( :X, '%' ) does not ask for X SELECT * FROM "Table" WHERE "Name" LIKE Concat( 'S', '%' ) my syntax is obviously right, except for the parameter. Please, don't tell me this is impossible. Greetings, Andreas --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
