combobox value (solved)

Maybe the query returns an array. I'm thinking Combobox3 list is from slujiteli table, right?  The details you gave is a little bit vague for we don't know the Checkbox1's sqlValue, etc. For starter, maybe your select query returns an array. Try adding LIMIT 1 in your query.

newprod.ComboBox3.dbItemID :=  SQLExecute('SELECT id FROM slujiteli WHERE Default = '+ newprod.CheckBox1.sqlValue +' LIMIT 1');

My advice, try debugging it by checking the newprod.CHeckbox1.sqlvalue, then run the query from a third party sqlite viewer to check if it really returns the correct id you are getting from database. It is also easier to work on it if you can send a simple application that address to your query.

Hi all,
You chose the name Default very badly.
https://www.sqlite.org/lang_keywords.html
Change the field name to something else, or change it to "Default" in the query.

newprod.ComboBox3.dbItemID :=  SQLExecute('SELECT id FROM slujiteli WHERE "Default" = '+ newprod.CheckBox1.sqlValue +'');

If you want to use a keyword as a name, you need to quote it. There are four ways of quoting keywords in SQLite:

    'keyword'        A keyword in single quotes is a string literal.
    "keyword"        A keyword in double-quotes is an identifier.
    `keyword`        A keyword enclosed in grave accents (ASCII code 96) is an identifier. This is not standard SQL. This quoting mechanism is used by MySQL and is included in SQLite for compatibility.