Hi, guys,
I put in this code:

                    if( sqlite3_prepare_v2( m_db, "PRAGMA
schema_version", NULL, &stmt, NULL ) == SQLITE_OK )
                    {
                        if( ( res = sqlite3_step( stmt ) ) == SQLITE_OK )
                        {
                            m_schema = sqlite3_column_int( stmt, 0 );
                            pimpl->m_dbName = sqlite_pimpl->m_catalog;
                        }
                        else
                        {
                        }
                    }
                    else
                    {
                    }

The call to sqlite3_step() failed - it returned 21.

Anyone sees any issues?

Thank you.

On Wed, Jun 20, 2018 at 6:32 AM, Simon Slavin <slav...@bigfraud.org> wrote:
> On 20 Jun 2018, at 12:29pm, Simon Slavin <slav...@bigfraud.org> wrote:
>
>> On 20 Jun 2018, at 7:24am, Peter Johnson <pe...@missinglink.co.nz> wrote:
>>
>>> Is it possible to create a trigger on sqlite_master which calls a
>>> user-defined function AFTER INSERT?
>>
>> No.  sqlite_master is modified using internal methods, not using an INSERT 
>> command.  TRIGGERs on it won't work.
>
> Are you not able to modify the program which adds so that it uses an existing 
> table instead ?
>
> Simon.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to