The table has many other columns but the inserting object is the client, that is unique, so for the already exists must not insert a new row. Is that correct?
Code: Select all
db->ExecuteUpdate(wxS("CREATE TABLE clients (id int unique, client blob unique, miniseis blob, daneia blob , kartes blob , logariasmoi blob , diafora blob )"));
Code: Select all
wxString sql=wxT("insert into clients ( client ) values ('");
sql+=cl.serialize();
sql+=wxT("')");
db->ExecuteUpdate(sql);
Thank you.
Jim