On Wed, 2006-03-01 at 16:53 +0100, Nicola Benaglia wrote: > Hi OpenOffice community, > I am experimenting the creation of a module with combo boxes and so on. > My underlying DB is postgres. > > My problem is that I want to create a combo box showing "surname name" > in a unique field: > > If I query from a console my DB with that syntax: > > select surname||' '||name from myTable > > I get the right expected output "surname [space] name" > > but inside a combo box in openoffice I get an error of syntax. > I also tried other characters like & + . | to merge two field in my > SELECT query > > Is there an OpenOffice syntax to use ? > Or is there another strategy to reach my goal? > > Thank you in advance, > Nicola
First thing: It works - I also run against PostgreSQL and have just tried it successfully. Type of List Content: SQL or SQL(Native) List Content: as you have above OOo version: 2.0.2rc4 (also worked in 2.0.1) If you're doing it via a predefined Query in Base (Type of List Content: Query), then make sure you select "Run SQL Query Directly" in the Base query designer. Regards. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
