I am beginning to work with sqlite and would like to read somehow the fields and field-types of a table. Can this be done? And if yes then how? Or maybe not with the standard-lib db_sqlite? With another one?
The reason is that I want to create a generalized database-form (in html) which I only give the table-name, and which extracts the necessary meta-info from the database. If it is not possible I could create a table in which I put this meta-info, but that would be extra work. Thanx in advance, Joris.
