Aaron Bockover wrote: > Internally in sqlite, everything is stored as a string, regardless of > what type a column was assigned during table creation. > > The only way to know the "type" is to parse the table definition from > the sqlite_master table. This should probably be done for convenience > inside Mono.Data.SqliteClient. > > For instance, run this query: > > SELECT sql FROM sqlite_master WHERE name="Tracks"; > > That will return the SQL used to create the "Tracks" table. You can then > parse that result to build a map of column names->types. > > There is some example code for this in Banshee: > http://cvs.gnome.org/viewcvs/*checkout*/banshee/src/Database.cs > > --Aaron
Thanks a lot, I'll look at it. _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
