U++ forum: Welcome to the forum

Re: How to manage the access to a Db on an unstable connection [message #50412 is a reply to message #50400]

Tue, 23 October 2018 10:46

Giorgio
Messages: 218
Registered: August 2015

Experienced Member

Hi Zbych,
thank you for your suggestions.

My routines that deal with the database have all the same structure:

int SaveData::TotalDrums(String c)
{
	int retval;
   	SQL.ClearError();
	try {
		retval = SQL % Select(SqlSum(DRUMS))
		 .From(MYTABLE)
 		 .Where( MYFIELD == AsString(c) );
	} catch(SqlExc) {
		retval = -1;
		ErrorOK(t_("Error: ") + SQL.GetLastError());
	}
	return retval;
}

Do you think I should catch also something else?
Is there on the upp site some documentation on ConnectionOK etcetera? I found almost nothing.
Regards,
gio

Report message to a moderator