[ python-Bugs-1733085 ] sqlite3 module trigger problem

[SourceForge.net]

Bugs item #1733085, was opened at 2007-06-07 23:36
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=105470&aid=1733085&group_id=5470

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Extension Modules
Group: Platform-specific
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Oinopion (oinopion)
Assigned to: Nobody/Anonymous (nobody)
Summary: sqlite3 module trigger problem

Initial Comment:
I and my team are building sqlite3 app and when used on Windows XP on Python 2.5.1 we get such an error:
 File "D:\studia\!bazy_projekt\svn2\src\muzzyk.py", line 39, in __init__
    cur.executescript(scheme)
OperationalError: near "NOT": syntax error
while parsing http://muzzyk.googlecode.com/svn/trunk/src/scheme.sql
Bug is about those triggers at the end of file.

On linux or with pysqlite2 imported instead of sqlite3 everything is OK.



----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=105470&aid=1733085&group_id=5470