U++ forum: Welcome to the forum

Re: SqlCtrls and IsModified() [message #27002 is a reply to message #26997]

Sun, 20 June 2010 17:53

mirek
Messages: 14266
Registered: November 2005

Ultimate Member

kropniczki wrote on Sat, 19 June 2010 14:01

I guess I see what you mean.
In my app context, however, I�m using push buttons on the main window to load table rows to a SqlCtrls set, so that users can navigate back and forth along the db table lines and alter them if desired. That�s why I must check whether changes occurred when moving from one row to the next and update them if that�s been the case.
In my app there�s no master SqlArr for users to pick a line from, for then editting the selected row in a SqlCtrls set in a pop-up dlg. Instead, it goes like,

SqlCtrls ctrls;
Value currendId;  // -> pointer to table row key id
...
ctrls
      (ID, idedit)
      (FIELD1, field1edit)
      ...
      (FIELDN, fieldnedit)
;
...
forwardbutton <<= THISBACK(MoveForward);
...
void MoveForward()
{
  if(ctrls.IsModified())
     SQL * ctrls.Update(TABLE).Where(ID == currentId);
  SQL * Select(SqlMin(ID)).From(TABLE).Where(ID > currentId));
  if(SQL.Fetch())
     currentId = SQL[0];
  ctrls.Load(SQL, TABLE, ID == currentId);
  ctrls.ClearModify(); // <-- reset modify flag
}

Thanks!

Something similar SqlArray can do for automagically. Just use AddCtrl method (of ArrayCtrl).

In fact, SqlCtrls were sort of derived from this arrangement to have something similar in dialogs.

Mirek

Report message to a moderator