The property is numeric and the may contain the following constants
in the current version.
0 - (default) Type info is returned as type constants
1 or 3 - .Type info is returned as a single string containing
semicolon ";" delimited list of type names for each column
in the result.
2 or 4 - The type info is returned as a collection of type names.
See Execute results for the
detailed description of the type information.
Assume we have the following table declaration:
CREATE TABLE T (
ID INTEGER PRIMARY KEY,
A NUMERIC,
B DATE,
C INTEGER,
D TEXT(20)
);
and we have some data in it so that the queries below return
some results. Assume the db is an initialized SQLite COM object
and the database is opened. Lets use this query:
Set r = db.Execute("SELECT ID,A,B,C,D,A+C AS E FROM T")
Then if we have several rows in the result. Assume RowN contains a
valid row index (e.g. smaller then the total number of the returned
rows).
If we want to display the values in this row together with their
types and row names we can use the following code lines:
If the TypeInfoLevel is set to 1 or 3:
arr = Split(result(RowN).Info,";")
For FieldN = 1 To result(RowN).Count
%>
<%= result(RowN).Key(FieldN) %>:<B><%= result(RowN)(FieldN) %></B> [<%= arr(FieldN - 1) %>]<BR>
<%
Next
If the TypeInfoLevel is set to 2 or 4:
For FieldN = 1 To result(RowN).Count
%>
<%= result(RowN).Key(FieldN) %>:<B><%= result(RowN)(FieldN) %></B> [<%= result(RowN).Info(FieldN) %>]<BR>
<%
Next
In both cases the result will look like this:
ID:3 [INTEGER]
A:6.25 [REAL]
B:38327.5695717593 [REAL]
C:25 [INTEGER]
D:Some text [TEXT]
E:31.25 [REAL]
