[RESOLVED] 3 problems

[manin]

Hello guys, I am trying to built a mysql application.
1. I have a checklistbox, with 25 items. Most of them reads it ok. When it reaches at "Birth Place", MySQL reads only "Birth". The string is ok, because before I send it to Mysql, I print it in textbox. Why is this happenning?
The items are in Greek, and mysql collumns.

Dim SQL As String
SQL = "SELECT " & ShowCol & " FROM ΠΡΟΣΩΠΙΚΟ WHERE AGE = '25'"
.....


Sub ChooseCols()
        Dim Num, i, j As Integer
            For i = 0 To frmSearch.CheckedListBox1.Items.Count - 1
            For j = 0 To frmSearch.CheckedListBox1.CheckedItems.Count - 1
                If j = 0 Then
                    ShowCol = frmSearch.CheckedListBox1.CheckedItems.Item(j)
                Else
                    ShowCol = ShowCol & ", " & frmSearch.CheckedListBox1.CheckedItems.Item(j)
                End If
            Next
        Next
        frmSearch.TextBox1.Text = ShowCol
    End Sub

2. My checklistbox needs 2 clicks to check an item. I want to do it with one click. I checked properties, but there isn't anything similar.

3. I want when I debug the programm, my default language to be greek. Is this possible?

[danasegarane]

2. My checklistbox needs 2 clicks to check an item. I want to do it with one click. I checked properties, but there isn't anything similar.

Set the CheckOnClick Property of the CheckedListBox to True

I am not sure what you are asking about the rest

[manin]

I am not sure what you are asking about the rest

For the first:
I use SQL string to retrieve from the database with SELECT.
ShowCol is a string that holds all cecked items from checklistbox.
ShowCol = frmSearch.CheckedListBox1.CheckedItems.Item(j).
All items are in greek, and I have no problem. I have problem with these that have a space (hire date). Mysql reads only one word, the first or the last...

for the third
when I run the application, I have to change language to write in greek. I want greek as default language in my application

[danasegarane]

You could have a look at the topic of ResourceFiles