[Firebird-odbc-devel] More changes for SQLGetInfo....

[<car...@te...>]

Hello:


Litte changes.


InfoItems.h

Add:

NITEM (SQL_SQL92_DATETIME_FUNCTIONS, 0)
NITEM (SQL_SQL92_FOREIGN_KEY_DELETE_RULE, 0)
NITEM (SQL_SQL92_FOREIGN_KEY_UPDATE_RULE, 0)
NITEM (SQL_SQL92_NUMERIC_VALUE_FUNCTIONS, 0)
NITEM (SQL_SQL92_RELATIONAL_JOIN_OPERATORS, 0)
NITEM (SQL_SQL92_ROW_VALUE_CONSTRUCTOR, 0)
NITEM (SQL_SQL92_STRING_FUNCTIONS, 0)
NITEM (SQL_SQL92_VALUE_EXPRESSIONS, 0)


OdbcConnection::sqlGetInfo


Add:

        case SQL_SQL92_DATETIME_FUNCTIONS:
            value |= SQL_SDF_CURRENT_DATE |
                     SQL_SDF_CURRENT_TIME |
                     SQL_SDF_CURRENT_TIMESTAMP;
            break;


        case SQL_SQL92_FOREIGN_KEY_DELETE_RULE:
            value |= SQL_SFKD_CASCADE    |
                     SQL_SFKD_NO_ACTION |
                     SQL_SFKD_SET_DEFAULT |
                     SQL_SFKD_SET_NULL;
            break;

        case SQL_SQL92_FOREIGN_KEY_UPDATE_RULE:
            value |= SQL_SFKU_CASCADE    |
                     SQL_SFKU_NO_ACTION |
                     SQL_SFKU_SET_DEFAULT |
                     SQL_SFKU_SET_NULL;
            break;


        case SQL_SQL92_RELATIONAL_JOIN_OPERATORS:
            {
                value = 0;
                if ( metaData->supportsANSI92EntryLevelSQL() )
                    value |= SQL_SRJO_LEFT_OUTER_JOIN |    // (FIPS 
Transitional level)
                             SQL_SRJO_NATURAL_JOIN    |    // (FIPS 
Transitional level)
                             SQL_SRJO_INNER_JOIN    |    // (FIPS 
Transitional level)
                             SQL_SRJO_RIGHT_OUTER_JOIN; // (FIPS 
Transitional level)

                if ( metaData->supportsANSI92IntermediateSQL() )
                    value |= SQL_SRJO_CORRESPONDING_CLAUSE |
                            SQL_SRJO_EXCEPT_JOIN |
                            SQL_SRJO_FULL_OUTER_JOIN |                   
         
                            SQL_SRJO_INTERSECT_JOIN;
            
                if ( metaData->supportsANSI92FullSQL() )
                    value |= SQL_SRJO_CROSS_JOIN |
                             SQL_SRJO_UNION_JOIN;
            }
            break;

        case SQL_SQL92_VALUE_EXPRESSIONS:
            {
                value = 0;
                if ( metaData->supportsANSI92EntryLevelSQL() )
                    value |= SQL_SVE_CAST; // (FIPS Transitional level)

                if ( metaData->supportsANSI92IntermediateSQL() )
                    value |= SQL_SVE_CASE |
                             SQL_SVE_COALESCE |
                             SQL_SVE_NULLIF;

                // if ( metaData->supportsANSI92FullSQL() )
            }
            break;



Best Regards
Carlos Guzmán Álvarez