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

[Boris Kolpackov]

Hi Rohith,

Tenneti, Rohith UTC CCS <Rohith.Tenneti at fs.utc.com> writes:

> #pragma db view
> struct integrity_check
> {
>   std::string problem;
> };
> 
> db->query < integrity_check >( "PRAGMA integrity_check" );
> 
> Which of course then resulted in a run time error at the PREPARE
> level as the query being executed was "WHERE PRAGMA integrity_check".

Ah, right, we don't consider PRAGMA as a complete statement. I've
fixed this and the (tiny) patch for libodb-sqlite is available here:

http://scm.codesynthesis.com/?p=odb/libodb-sqlite.git;a=patch;h=0d099d1930b1870db7f20761388b9772d0abfedc

Boris