openoffice base combo box multiple columns

We will protect our employee-ID field, then then change the sort order of our table to sort the records by last name (instead of employe-ID), then add some buttons to our form to allow us to select the next and previous records.Ĭlick here to Download: odb09-ProtectAField Add Buttons.odbĪn introduction to the filter on the navitgation toolbar, how to change the background color/insert a background graphic also adding a logo on your form.Ĭlick here to Download: odb10-Filter Background.odbĬlick here to Download: odb10-Gender-Text-VarChar.odbĪdd a radio button to replace the Gender Textbox on an updated version of odb10, then we take the original odb10 output change the Gender field type from Fixed Character to VarChar, then we need to update the data in that field, then we can add the radio buttons and check out the data source.Ĭlick here to Download: odb11a-Radio-Button.odbĬlick here to Download: odb11b-Gender-Text-VarChar.odbįirst we show how to do a date drop down down box, then we format a date on our table and show how to get the date formatting from the table, then we will create a new field (on our table) with a dollar value and have it show on our form with a dollar sign.Ĭlick here to Download: odb12-Dates and Dollar Signs.odb Video 9 - Protect a Field, Sort, Add Buttons.But I can't find something like a client_encoding setting in OpenOffice Base. so I thought that might have somethig to do with it. Then on this site I read the question and answer on: įirst I thought I could correct this by setting:ĭatabase->open and existing database file->right click to go to 'database properties'->set Data conversion character set to 'Unicode (UTF->save)īut that doesn't help. The first line is cut from pgAdmin and pasted into OOwriter.

The same text through a mail merge only shows question marks. When I cut a text from the GUI and paste this text in OOwriter everything works well. when I access the database from pgAdmin, a GUI client I can see all UTF-8 encoded characters. This seems to work except for non western characters. I have a PostgreSQL database encode in UTF-8.

Openoffice base combo box multiple columns