U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » Sqlite Column Types

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Sqlite Column Types [message #1487]

Mon, 06 March 2006 15:16

abarilla
Messages: 9
Registered: March 2006

Promising Member

I changed some code in my copy of the Sqlite3upp.cpp file to correctly assign a column type for use in the the GetColumnInfo() function.

In the procedure:

Vector<SqlColumnInfo> Sqlite3Session::EnumColumns(String database, String table)

Replace:

info.type = STRING_V;

With this:

switch (sqlite3_column_type(s, i)) {
    case 1:
        info.type = INT_V;
        break;
    case 2:
        info.type = DOUBLE_V;
        break;
    default:
        info.type = STRING_V;
}

This sets blobs to STRING_V still because I don't see a blob type constant in upp.

Report message to a moderator