> -----Original Message----- > From: Ken & Deb Allen [mailto:[EMAIL PROTECTED] > Sent: Monday, August 15, 2005 4:44 PM > To: [email protected] > Subject: [sqlite] Problems using SQLITE .Net Data Provider (Windows) > > I recently downloaded the (Finisar) .Net Data Provider for > SQLITE from SourceForge in order to use this in a C# > applications under Windoes XP. I had a few small problems > getting the database created at all via .Net, but that is > working, and I was able to also define the schema for my > database using CREATE TABLE, CREATE TRIGGER and CREATE INDEX > statements.
Hopefully you posted this on the Sourceforge forums for the Finisar SQLite library ... I'm afraid the issues you describe are all beyond the scope of this mailing list. However, to answer your question (or at least attempt to) ... If I recall correctly, one of the things the Finisar library does is pre-parse (as best it can) your SQL statements before passing them to the underlying database engine. It sounds like all your issues are related to the parser. If you (or anyone else for that matter) is planning on switching to .NET 2.0 and Visual Studio 2005, it might be worth your while to check out the .Net 2.0 provider currently complete and being beta-tested: http://sourceforge.net/projects/sqlite-dotnet2 Robert
