Cursor cursor = db.rawQuery("Select NrCl||';'||Nome From Clientes", null);
final ListView t = (ListView)findViewById(R.id.cli_lista);
ArrayAdapter myarrayAdapter = new ArrayAdapter(this, android.R.layout.simple_expandable_list_item_1, listItems);
t.setAdapter(myarrayAdapter);

final ListView td = (ListView)findViewById(R.id.cli_lista_detalhe);
final ArrayAdapter myarrayAdapter2 = new ArrayAdapter(this, android.R.layout.simple_expandable_list_item_1, listItems2);

t.setOnItemClickListener(new OnItemClickListener() {
    @Override
    public void onItemClick(AdapterView> parent, View view, int position, long id) {
        String item = ((TextView)view).getText().toString();
        String[] strArray = item.split("\\;");

        cli.load(strArray[0].toString());
        td.setAdapter(myarrayAdapter2);
        listItems2.clear();
        listItems2.add("Nome: "   cli.getNome());
        listItems2.add("Morada: "   cli.getMorada());
        listItems2.add("Localidade: "   cli.getLoca());
        listItems2.add("Código Postal: "   cli.getCp());
        listItems2.add("Pais: "   cli.getPais());
        listItems2.add("Nif: "   cli.getNif());
        listItems2.add("Tel: "   cli.getTel());
        listItems2.add("Tlm: "   cli.getTlm());
        listItems2.add("Tipo Preço: "   cli.getTipoPvn());
        listItems2.add("Cond. Pagamento: "   cli.getCpg());
        listItems2.add("Obs: "   cli.getObs());
        td.setAdapter(myarrayAdapter2);
        myarrayAdapter2.notifyDataSetChanged();
    }
});