[Firebird-odbc-devel] Another little modification for SQLGetTypeInfo

[Carlos G.A. <car...@ho...>]

Hello:

I made a little modificationover the files that i post in my last message:

TypeResultSet.cpp:

struct Types {
	char	*typeName;
	int	typeType;
	long	typePrecision;
	char	*typePrefix;
	char	*typeSuffix;
	char	*typeParams;
	int	typeNullable;
	int	typeCaseSensitive;
	int	typeSearchable;
	int	typeUnsigned;
	int	typeMoney;
	int	typeAutoIncrement;
	char	*typeLocalName;
	int	typeMinScale;
	int	typeMaxScale;
	};

....
....

#define ALPHA(type,code,prec) 
type,code,prec,"'","'","length",NULLABLE,CASE_SENSITIVE,SEARCHABLE,NOT_NUMERIC,NOT_NUMERIC,NOT_NUMERIC,type,UNSCALED,UNSCALED
#define BLOB(type,code,prefix,suffix) 
type,code,2147483647,prefix,suffix,NULL,NULLABLE,CASE_SENSITIVE,UNSEARCHABLE,NOT_NUMERIC,NOT_NUMERIC,NOT_NUMERIC,type,UNSCALED,UNSCALED
#define NUMERIC(type,code,prec,attr,min,max) 
type,code,prec,NULL,NULL,attr,NULLABLE,CASE_INSENSITIVE,SEARCHABLE_EXCEPT_LIKE,IS_SIGNED,NOT_MONEY,NOT_AUTO_INCR,type,min,max
#define DATETIME(type,code,prec,prefix,suffix) 
type,code,prec,prefix,suffix,NULL,NULLABLE,CASE_INSENSITIVE,SEARCHABLE_EXCEPT_LIKE,NOT_NUMERIC,NOT_NUMERIC,NOT_AUTO_INCR,type,NULL,NULL

static const Types types [] = {
	ALPHA ("CHAR", jdbcCHAR,32767),
	ALPHA ("VARCHAR", VARCHAR,32765),
	NUMERIC ("NUMERIC", TYPE_SQL_NUMERIC, 18, "precision,scale", 0, 18),
	NUMERIC ("DECIMAL", TYPE_SQL_DECIMAL, 18, "precision,scale", 0, 18),
	NUMERIC ("SMALLINT", SMALLINT, 5, NULL, 0, 0),
	NUMERIC ("INTEGER", INTEGER, 10, NULL, 0, 0),
	NUMERIC ("FLOAT", jdbcFLOAT, 15, NULL, 0, 0),
	NUMERIC ("DOUBLE PRECISION", jdbcDOUBLE, 15, NULL, 0, 0),
	BLOB ("LONG VARCHAR", TYPE_SQL_LONGVARCHAR,"'","'"),
	BLOB ("LONG VARBINARY", TYPE_SQL_LONGVARBINARY,NULL,NULL),
	DATETIME("DATE",jdbcDATE,10,"{d'","'}"),
	DATETIME("TIME",TIME,8,"{t'","'}"),
	DATETIME("TIMESTAMP",TIMESTAMP,23,"{ts'","'}"),
	};


Best Regards
Carlos Guzman Álvarez
Vigo-España

_________________________________________________________________
Únase al mayor servicio mundial de correo electrónico: 
http://www.hotmail.com/es