On Sep 3, 2011, at 8:21 PM, Walter wrote: > > On 9/2/2011 11:02 PM, Walter wrote: > >> > Is there any way to get the user_version from an Attached database >> > PRAGMA attachedName.user_version; > > -- Igor Tandetnik Thank you Igor I had the database name but did not think of > the the dot in between. Perhaps some one could update the documentation to > show this Cheers everyone Walter >
it is a pretty common SQL convention, using periods to separate the database_from.schema_from.table_from.column You don't have to specify the left-side qualifier if the entity on the right of the period can be located unambiguously. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users