Home News DOC Class DL Others Rice
Class  >  dbreader  >  FieldType(string)
dbreader class : FieldType(string) method

Description

Returns the type of the specified column.

Syntax

instance.FieldType(string columnName)

Arguments

ClassNameDescription
stringcolumnNameColumn name.

Return value

ClassDescription
stringType name.

Sample code

1:

connection cnn = new connection("Data Source=c:\somedirectory\somedatabase.sqlite3;Version=3;");

2:

cnn.Open();

3:

command cmm = new command("select * from sometable where id < 100;", cnn);

4:

dbreader dbr = cmm.Reader(); // Command execution. Returns multi-line results.

5:

while(dbr.Read())

6:

string typename = dbr.FieldType("Appropriate column name"); // The type name of the column.

7:

endwhile

8:

dbr.Release();

9:

cmm.Release();

10:

cnn.Close();

11:

cnn.Release();

Notes

The type name returned by this method is the type name on the database. The return value from the database is returned as a string.

If the column corresponding to the argument does not exist, an exception, UnknownException, will be thrown.

Links for reference

None.

Copyright © Rice All rights reserved.