U++ forum: Welcome to the forum

Strange exception raising with SQL.ExecuteX() [message #30104]

Thu, 09 December 2010 10:54

BioBytes
Messages: 307
Registered: October 2008
Location: France

Senior Member

Hi all,

The following code, which compiles correctly, raises an exception while the updating operations are correctly implemented in my database tables:

void qsSKillFormDlg::RefreshInfosProcOwner(String newValue,String owner,int fieldId)
{
SqlId TBLOWN("OWNERS"),FIRSTNAME("OWNERFIRSTNAME"),FAMILYNAME( "OWNERNAME");
Vector<String> infos;

try
{
infos.Clear();
infos = Split(infosProcOwner.At(2),' ',false);

switch(fieldId)
{
case 0: infosProcOwner.At(2).Clear();
infosProcOwner.At(2)<<infos.At(0)<<' '<<newValue;
SQL.ExecuteX(" Update(TBLOWN)(FAMILYNAME,newValue).Where(FAMILYNAME==owner) ");

break;

case 1: SQL.ExecuteX("Update(TBLOWN)(FIRSTNAME,newValue).Where(FAMILYNAME==owner) ");
break;
}
}
catch(SqlExc& err)
{
PanicMessageBox(t_("Erreur SQL"),err);
}
}

I use MySql Server 5.0 and U++ 2884. Of course, if I replace ExecuteX and no longer implement the exception Try/Catch, no error is shown in runtime.

Perhaps I misuse the SqlId syntax or is there a bug?. Is anyone has an idea ?

Thanks for suggestions

Regards

Biobytes

Report message to a moderator