U++ forum: Welcome to the forum

Re: Reading S_xxxx records from Sql [message #39077 is a reply to message #38884]

Wed, 13 February 2013 08:30

sergeynikitin
Messages: 748
Registered: January 2008
Location: Moscow, Russia

Contributor

If you use not all fields in your sql schema, then SqlAll() may transfer unwanted fields (maybe BLOBs...).

rec transfers fields only present in your schema.

PS
For screen buffer to read DataFileRecord use SqlCtrls screen sctructure in header file of window class.

SqlCtrls ctrls;

and in constructor

ctrls
   (sqlfield1,dlg.ScreenField1)
   (sqlfield2,dlg.ScreenField2)
   (sqlfield3,dlg.ScreenField3)
   (sqlfield4,dlg.ScreenField4)
;

And when you read record use this code:

SQL * Select(dlg.ctrls).From(TABLE).Where(TAB_ID == ptr);
if(!dlg.ctrls.Fetch(SQL))
   return;

SergeyNikitin<U++>( linux, wine )
{
under( Ubuntu || Debian || Raspbian );
}

Report message to a moderator