[odb-users] Output of native SQL statement in SQLite.

[Tenneti, Rohith UTC CCS]

Hello,

I am trying to capture the output of SQL statement in SQLite "PRAGMA integrity_check;" using :

        session s;
        transaction t( db->begin() );

        numRows = db->execute("PRAGMA integrity_check");

        t.commit();


As per the ODB manual, db->execute returns the number of rows affected. Is it possible to capture the output i.e.,

        sqlite> pragma integrity_check;
        integrity_check
        ---------------
        Ok

Thank you

[cid:image003.png at 01D07790.413FA370]

Rohith Tenneti
Firmware Engineer
Control Panels & Interfaces

EDWARDS Detection & Alarm
8985 Town Center Parkway
Bradenton, FL 34202
Landline: (941) 739-4263
Email: Rohith.Tenneti at fs.utc.com<mailto:Rohith.Tenneti at fs.utc.com>


Note: This message is intended only for the designated recipient(s). It may contain confidential or proprietary information and may be subject to the attorney-client privilege or other confidentiality protections. If you are not a designated recipient, you may not review, copy or distribute this message.  If you receive this in error, please notify the sender by reply e-mail and delete this message. Thank you.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 11350 bytes
Desc: image001.png
Url : http://codesynthesis.com/pipermail/odb-users/attachments/20170109/d512a98e/image001.png