SQLite user_version() expression

Posted by ralf.w. on Stack Overflow See other posts from Stack Overflow or by ralf.w.
Published on 2010-06-17T14:01:49Z Indexed on 2010/06/17 14:03 UTC
Read the original article Hit count: 171

Filed under:

sqlite

|

extension-methods

how can I get user_version into an expression (for SELECT or WHERE) ?

I would also appreciate any clue to how to save ANY global variable in SQLite.

Does anyone know of such an extension (dll) ?

BTW: I know that PRAGMA user_version; gives me the right answer, but I cannot use that inside a WHERE-clause !

© Stack Overflow or respective owner

Related posts about sqlite

How to add SQLite (SQLite.NET) to my C# project

as seen on Stack Overflow - Search for 'Stack Overflow'
I followed the instructions in the documentation: Scenario 1: Version Independent (does not use the Global Assembly Cache) This method allows you to drop any new version of the System.Data.SQLite.DLL into your application's folder and use it without any code modifications or recompiling… >>> More
dotConnect or "sqlite.phxsoftware.com" for using Entity Framework with SQLite

as seen on Stack Overflow - Search for 'Stack Overflow'
Which is the better choice out of dotConnect or "sqlite.phxsoftware.com" for using Entity Framework with SQLite (in C#)? >>> More
SQLite table does not exist exception for existing SQLite database (and table)

as seen on Stack Overflow - Search for 'Stack Overflow'
I've followed the instructions given here for introducing an existing SQLite database to your Android app. When I query the table "android_metadata" this is fine. But when I run a similar query on my own table "words" (which has _id for primary integer key) I get a table does not exist exception… >>> More
Android Jelly bean database is locked (code 5)

as seen on Stack Overflow - Search for 'Stack Overflow'
Im getting a database is locked (code 5) in my ListActivity the code works in the other versions of the Emulator but fails in the 4.1 version of the emulator E/SQLiteLog( 2132): (5) database is locked E/SQLiteDatabase( 2132): Failed to open database '/data/data/id.online.mydroid/databases/geo… >>> More
Android:accessing assets folder sqlite databse file with .sqlite extension

as seen on Stack Overflow - Search for 'Stack Overflow'
How to read data from the assets folder sqlite database file with .sqlite extension in my android application? Thanks >>> More

Related posts about extension-methods

Collect all extension methods to generic class in another generic class

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to create a lot of extension methods for some generic class, e.g. for public class SimpleLinkedList<T> where T:IComparable And I've started creating methods like this: public static class LinkedListExtensions { public static T[] ToArray<T>(this SimpleLinkedList<T>… >>> More
Lambdas within Extension methods: Possible memory leak?

as seen on Stack Overflow - Search for 'Stack Overflow'
I just gave an answer to a quite simple question by using an extension method. But after writing it down i remembered that you can't unsubscribe a lambda from an event handler. So far no big problem. But how does all this behave within an extension method?? Below is my code snipped again. So can… >>> More
Having trouble with extension methods for byte arrays

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm working with a device that sends back an image, and when I request an image, there is some undocumented information that comes before the image data. I was only able to realize this by looking through the binary data and identifying the image header information inside. I've been able to make… >>> More
Extension Methods in Dot Net 2.0

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Not that anyone would still need this, but in case you have a situation where the code MUST be .NET 2.0 compliant and you want to use a cool feature like Extension methods, there is a way. I saw this article when looking for ways to create extension methods in C++, C# and VB: http://msdn.microsoft… >>> More
Prefer extension methods for encapsulation and reusability?

as seen on Stack Overflow - Search for 'Stack Overflow'
edit4: wikified, since this seems to have morphed more into a discussion than a specific question. In C++ programming, it's generally considered good practice to "prefer non-member non-friend functions" instead of instance methods. This has been recommended by Scott Meyers in this classic Dr. Dobbs… >>> More