[Firebird-odbc-devel] IscProcedureColumnsResultSet::getProcedureColumns

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

Hello:

The SQL is bad should be ( IscProcedureColumnsResultSet::getProcedureColumns 
):

	JString sql =
		"select NULL as table_cat,\n"								// 1
				"\tNULL as table_schem,\n"							// 2
				"\tpp.rdb$procedure_name as procedure_name,\n"			// 3
				"\tpp.rdb$parameter_name as column_name,\n"			// 4
				"\tpp.rdb$parameter_type as column_type,\n"			// 5
				"\tf.rdb$field_type as data_type,\n"					// 5 + 1
				"\tf.rdb$field_sub_type as type_name,\n"				// 6 + 1
				"\tf.rdb$field_length as column_size,\n"				// 7 + 1
				"\tnull as buffer_length,\n"						// 8 + 1
				"\tf.rdb$field_scale as decimal_digits,\n"			// 9 + 1
				"\t10 as num_prec_radix,\n"							// 10 + 1
				"\tf.rdb$null_flag as nullable,\n"					// 11 + 1
				"\tf.rdb$description as remarks,\n"					// 12 + 1
				"\tf.rdb$default_value as column_def,\n"				// 13 + 1
				"\tnull as SQL_DATA_TYPE,\n"						// 14 + 1
				"\tnull as SQL_DATETIME_SUB,\n"						// 15 + 1
				"\tf.rdb$field_length as CHAR_OCTET_LENGTH,\n"		// 16 + 1
				"\tpp.rdb$parameter_number as ordinal_position,\n"		// 17 + 1
				"\t'YES' as IS_NULLABLE\n"							// 18 + 1
		"from rdb$procedure_parameters pp, rdb$fields f\n"
		"where pp.rdb$field_source = f.rdb$field_name";



Best Regards
Carlos Guzman Alvarez
Vigo-España

_________________________________________________________________
Descargue GRATUITAMENTE MSN Explorer en 
http://explorer.yupimsn.com/intl.asp.