Hi, On Tue, May 22, 2012 at 12:51 PM, activa <[email protected]> wrote: > > Rolf Bjarne Kvinge wrote >> >> >> This is because the sqlite library included in iOS don't have support for >> querying column metadata. You can still build your own libcustomsqlite.a >> and use that instead (how to: http://stackoverflow.com/a/5602717/183422) >> >> > > It's perfectly possible to get all the key information in MonoTouch using > *pragma table_info()* (I do it in the MonoTouch SQLite driver for > CoolStorage). So it's odd that the MonoTouch's GetSchemaTable() isn't able > to return that information.
This is not as easy as it looks at first sight: GetSchemaTable gets schema for any sql statement, so the problem isn't getting the schema information for column X in table Y, but to determine which column/table a particular column in an sql query belongs to. For example: SELECT tablex.x AS foo, tabley.y AS bar; How do you determine that 'foo' is really from tablex.x and that 'bar' is really from tabley.y? Rolf > > -- > View this message in context: > http://monotouch.2284126.n4.nabble.com/Key-information-not-returned-in-GetSchemaTable-tp4649539p4649682.html > Sent from the MonoTouch mailing list archive at Nabble.com. > _______________________________________________ > MonoTouch mailing list > [email protected] > http://lists.ximian.com/mailman/listinfo/monotouch _______________________________________________ MonoTouch mailing list [email protected] http://lists.ximian.com/mailman/listinfo/monotouch
