|
Hello everyone.
I have been using Backbase since 4.0 version but now with the new 4.1 version my queries aren't working well. For instance, I have the next xml file (pay special attention in tables node):
<DatabaseSchema Productname="MySQL" DriverName="MySQL-AB JDBC Driver" DataBaseProductName="MySQL" DataBaseProductversion="5.0.16-nt-max" SchemaTerm="" CatalogTerm="database" ProcedureTerm="PROCEDURE" TransactionIsolationLevel="2" SQL92Level="Entry" suppOutersJoins="yes" suppStoredProced="yes" suppSubQueriesInComparisions="yes" suppSubQueriesInExists="yes" suppSubQueriesInIns="yes" suppTransactions="yes" suppUnion="yes" suppUnionAll="yes" suppSelectForUpdate="yes" suppNoNullablesColumns="yes" suppSchemasInDataMan="no" suppSchemasInTableMan="no" SQLKeywords="AUTO_INCREMENT,BINARY,BLOB,ENUM,INFILE,LOAD,MEDIUMINT,OPTION,OUTFILE,REPLACE,SET,TEXT,UNSIGNED,ZEROFILL" NumericFunctions="ABS,ACOS,ASIN,ATAN,ATAN2,BIT_COUNT,CEILING,COS,COT,DEGREES,EXP,FLOOR,LOG,LOG10,MAX,MIN,MOD,PI,POW,POWER,RADIANS,RAND,ROUND,SIN,SQRT,TAN,TRUNCATE" StringFunctions="ASCII,BIN,BIT_LENGTH,CHAR,CHARACTER_LENGTH,CHAR_LENGTH,CONCAT,CONCAT_WS,CONV,ELT,EXPORT_SET,FIELD,FIND_IN_SET,HEX,INSERT,INSTR,LCASE,LEFT,LENGTH,LOAD_FILE,LOCATE,LOCATE,LOWER,LPAD,LTRIM,MAKE_SET,MATCH,MID,OCT,OCTET_LENGTH,ORD,POSITION,QUOTE,REPEAT,REPLACE,REVERSE,RIGHT,RPAD,RTRIM,SOUNDEX,SPACE,STRCMP,SUBSTRING,SUBSTRING,SUBSTRING,SUBSTRING,SUBSTRING_INDEX,TRIM,UCASE,UPPER" SystemFunctions="DATABASE,USER,SYSTEM_USER,SESSION_USER,PASSWORD,ENCRYPT,LAST_INSERT_ID,VERSION" DateTimeFunctions="DAYOFWEEK,WEEKDAY,DAYOFMONTH,DAYOFYEAR,MONTH,DAYNAME,MONTHNAME,QUARTER,WEEK,YEAR,HOUR,MINUTE,SECOND,PERIOD_ADD,PERIOD_DIFF,TO_DAYS,FROM_DAYS,DATE_FORMAT,TIME_FORMAT,CURDATE,CURRENT_DATE,CURTIME,CURRENT_TIME,NOW,SYSDATE,CURRENT_TIMESTAMP,UNIX_TIMESTAMP,FROM_UNIXTIME,SEC_TO_TIME,TIME_TO_SEC">
<Connection driver="com.mysql.jdbc.Driver" user="test">
jdbc:mysql://localhost:3306/test?zeroDateTimeBehavior=convertToNull
<Catalogs>
<Catalog>information_schema</Catalog>
<Catalog>test</Catalog>
</Catalogs>
<Schemas />
<TableTypes />
</Connection>
<DataTypes>
<type type_name="BIT" data_type="-7" precision="1" literal_prefix="" literal_suffix="" create_paramsS="" nullable="1" case_sensitive="true" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="BIT" minimum_scale="0" maximum_scale="0" />
<type type_name="BOOL" data_type="-7" precision="1" literal_prefix="" literal_suffix="" create_paramsS="" nullable="1" case_sensitive="true" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="BOOL" minimum_scale="0" maximum_scale="0" />
<type type_name="TINYINT" data_type="-6" precision="3" literal_prefix="" literal_suffix="" create_paramsS="[(M)] [UNSIGNED] [ZEROFILL]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="true" auto_increment="true" local_type_name="TINYINT" minimum_scale="0" maximum_scale="0" />
<type type_name="BIGINT" data_type="-5" precision="19" literal_prefix="" literal_suffix="" create_paramsS="[(M)] [UNSIGNED] [ZEROFILL]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="true" auto_increment="true" local_type_name="BIGINT" minimum_scale="0" maximum_scale="0" />
<type type_name="LONG VARBINARY" data_type="-4" precision="16777215" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="true" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="LONG VARBINARY" minimum_scale="0" maximum_scale="0" />
<type type_name="MEDIUMBLOB" data_type="-4" precision="16777215" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="true" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="MEDIUMBLOB" minimum_scale="0" maximum_scale="0" />
<type type_name="LONGBLOB" data_type="-4" precision="2147483647" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="true" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="LONGBLOB" minimum_scale="0" maximum_scale="0" />
<type type_name="BLOB" data_type="-4" precision="65535" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="true" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="BLOB" minimum_scale="0" maximum_scale="0" />
<type type_name="TINYBLOB" data_type="-4" precision="255" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="true" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="TINYBLOB" minimum_scale="0" maximum_scale="0" />
<type type_name="VARBINARY" data_type="-3" precision="255" literal_prefix="'" literal_suffix="'" create_paramsS="(M)" nullable="1" case_sensitive="true" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="VARBINARY" minimum_scale="0" maximum_scale="0" />
<type type_name="BINARY" data_type="-2" precision="255" literal_prefix="'" literal_suffix="'" create_paramsS="(M)" nullable="1" case_sensitive="true" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="BINARY" minimum_scale="0" maximum_scale="0" />
<type type_name="LONG VARCHAR" data_type="-1" precision="16777215" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="LONG VARCHAR" minimum_scale="0" maximum_scale="0" />
<type type_name="MEDIUMTEXT" data_type="-1" precision="16777215" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="MEDIUMTEXT" minimum_scale="0" maximum_scale="0" />
<type type_name="LONGTEXT" data_type="-1" precision="2147483647" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="LONGTEXT" minimum_scale="0" maximum_scale="0" />
<type type_name="TEXT" data_type="-1" precision="65535" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="TEXT" minimum_scale="0" maximum_scale="0" />
<type type_name="TINYTEXT" data_type="-1" precision="255" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="TINYTEXT" minimum_scale="0" maximum_scale="0" />
<type type_name="CHAR" data_type="1" precision="255" literal_prefix="'" literal_suffix="'" create_paramsS="(M)" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="CHAR" minimum_scale="0" maximum_scale="0" />
<type type_name="NUMERIC" data_type="2" precision="17" literal_prefix="" literal_suffix="" create_paramsS="[(M[,D])] [ZEROFILL]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="true" local_type_name="NUMERIC" minimum_scale="-308" maximum_scale="308" />
<type type_name="DECIMAL" data_type="3" precision="17" literal_prefix="" literal_suffix="" create_paramsS="[(M[,D])] [ZEROFILL]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="true" local_type_name="DECIMAL" minimum_scale="-308" maximum_scale="308" />
<type type_name="INTEGER" data_type="4" precision="10" literal_prefix="" literal_suffix="" create_paramsS="[(M)] [UNSIGNED] [ZEROFILL]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="true" auto_increment="true" local_type_name="INTEGER" minimum_scale="0" maximum_scale="0" />
<type type_name="INT" data_type="4" precision="10" literal_prefix="" literal_suffix="" create_paramsS="[(M)] [UNSIGNED] [ZEROFILL]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="true" auto_increment="true" local_type_name="INT" minimum_scale="0" maximum_scale="0" />
<type type_name="MEDIUMINT" data_type="4" precision="7" literal_prefix="" literal_suffix="" create_paramsS="[(M)] [UNSIGNED] [ZEROFILL]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="true" auto_increment="true" local_type_name="MEDIUMINT" minimum_scale="0" maximum_scale="0" />
<type type_name="SMALLINT" data_type="5" precision="5" literal_prefix="" literal_suffix="" create_paramsS="[(M)] [UNSIGNED] [ZEROFILL]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="true" auto_increment="true" local_type_name="SMALLINT" minimum_scale="0" maximum_scale="0" />
<type type_name="FLOAT" data_type="7" precision="10" literal_prefix="" literal_suffix="" create_paramsS="[(M,D)] [ZEROFILL]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="true" local_type_name="FLOAT" minimum_scale="-38" maximum_scale="38" />
<type type_name="DOUBLE" data_type="8" precision="17" literal_prefix="" literal_suffix="" create_paramsS="[(M,D)] [ZEROFILL]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="true" local_type_name="DOUBLE" minimum_scale="-308" maximum_scale="308" />
<type type_name="DOUBLE PRECISION" data_type="8" precision="17" literal_prefix="" literal_suffix="" create_paramsS="[(M,D)] [ZEROFILL]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="true" local_type_name="DOUBLE PRECISION" minimum_scale="-308" maximum_scale="308" />
<type type_name="REAL" data_type="8" precision="17" literal_prefix="" literal_suffix="" create_paramsS="[(M,D)] [ZEROFILL]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="true" local_type_name="REAL" minimum_scale="-308" maximum_scale="308" />
<type type_name="VARCHAR" data_type="12" precision="255" literal_prefix="'" literal_suffix="'" create_paramsS="(M)" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="VARCHAR" minimum_scale="0" maximum_scale="0" />
<type type_name="ENUM" data_type="12" precision="65535" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="ENUM" minimum_scale="0" maximum_scale="0" />
<type type_name="SET" data_type="12" precision="64" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="SET" minimum_scale="0" maximum_scale="0" />
<type type_name="DATE" data_type="91" precision="0" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="DATE" minimum_scale="0" maximum_scale="0" />
<type type_name="TIME" data_type="92" precision="0" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="TIME" minimum_scale="0" maximum_scale="0" />
<type type_name="DATETIME" data_type="93" precision="0" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="DATETIME" minimum_scale="0" maximum_scale="0" />
<type type_name="TIMESTAMP" data_type="93" precision="0" literal_prefix="'" literal_suffix="'" create_paramsS="[(M)]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="TIMESTAMP" minimum_scale="0" maximum_scale="0" />
</DataTypes>
<tables>
<table name="AEROPUERTO" type="TABLE" table_cat="test" remarks="">
<columns>
<column name="IDAEROPUERTO" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="NOMBREA" remarks="" type_name="varchar" data_type="12" length="50" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="CIUDADA" remarks="" type_name="varchar" data_type="12" length="20" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="ESTADOA" remarks="" type_name="varchar" data_type="12" length="20" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="PAISA" remarks="" type_name="varchar" data_type="12" length="25" decimal_digits="0" nullable="1" is_nullable="YES" />
</columns>
<primaryKeys>
<column name="IdAeropuerto" position="1" />
</primaryKeys>
<foreingKeys />
</table>
<table name="BOLETO" type="TABLE" table_cat="test" remarks="">
<columns>
<column name="IDBOLETO" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="TIPOBOLETO" remarks="" type_name="enum" data_type="1" length="2" decimal_digits="0" nullable="1" is_nullable="YES" />
<column name="IDCLIENTE" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="IDVUELO" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
</columns>
<primaryKeys>
<column name="IdBoleto" position="1" />
</primaryKeys>
<foreingKeys>
<fkTable fkTableName="cliente" pkTableName="BOLETO">
<pkColumn pkColumnName="IdCliente" fkColumnName="IdCliente" KeySecuence="1" updateRule="importedKeyCascade" deleteRule="importedKeyCascade" deferrability="importedKeyNotDeferrable" />
</fkTable>
<fkTable fkTableName="vuelo" pkTableName="BOLETO">
<pkColumn pkColumnName="IdVuelo" fkColumnName="IdVuelo" KeySecuence="1" updateRule="importedKeyCascade" deleteRule="importedKeyCascade" deferrability="importedKeyNotDeferrable" />
</fkTable>
</foreingKeys>
</table>
<table name="CLIENTE" type="TABLE" table_cat="test" remarks="">
<columns>
<column name="IDCLIENTE" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="CURP" remarks="" type_name="varchar" data_type="12" length="18" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="NOMBRE" remarks="" type_name="varchar" data_type="12" length="20" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="APEPAT" remarks="" type_name="varchar" data_type="12" length="20" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="APEMAT" remarks="" type_name="varchar" data_type="12" length="20" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="TEL" remarks="" type_name="varchar" data_type="12" length="10" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="SEXO" remarks="" type_name="enum" data_type="1" length="2" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="PASAPORTE" remarks="" type_name="varchar" data_type="12" length="11" decimal_digits="0" nullable="1" is_nullable="YES" />
</columns>
<primaryKeys>
<column name="IdCliente" position="1" />
</primaryKeys>
<foreingKeys />
</table>
<table name="DIRECCION" type="TABLE" table_cat="test" remarks="">
<columns>
<column name="IDDIRECCION" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="CALLE" remarks="" type_name="varchar" data_type="12" length="20" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="NUMEXT" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="NUMINT" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="COLONIA" remarks="" type_name="varchar" data_type="12" length="20" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="MUNICIPIO" remarks="" type_name="varchar" data_type="12" length="20" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="ESTADO" remarks="" type_name="varchar" data_type="12" length="20" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="CP" remarks="" type_name="varchar" data_type="12" length="5" decimal_digits="0" nullable="1" is_nullable="YES" />
<column name="IDCLIENTE" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="1" is_nullable="YES" />
</columns>
<primaryKeys>
<column name="IdDireccion" position="1" />
</primaryKeys>
<foreingKeys>
<fkTable fkTableName="cliente" pkTableName="DIRECCION">
<pkColumn pkColumnName="IdCliente" fkColumnName="IdCliente" KeySecuence="1" updateRule="importedKeyCascade" deleteRule="importedKeyCascade" deferrability="importedKeyNotDeferrable" />
</fkTable>
</foreingKeys>
</table>
<table name="MODELO" type="TABLE" table_cat="test" remarks="">
<columns>
<column name="IDMODELO" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="DISPTUR" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="1" is_nullable="YES" />
<column name="DISPPRI" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="1" is_nullable="YES" />
</columns>
<primaryKeys>
<column name="IdModelo" position="1" />
</primaryKeys>
<foreingKeys />
</table>
<table name="RUTA" type="TABLE" table_cat="test" remarks="">
<columns>
<column name="IDRUTA" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="DURACION" remarks="" type_name="float" data_type="7" length="12" decimal_digits="0" nullable="1" is_nullable="YES" />
<column name="COSTOTUR" remarks="" type_name="float" data_type="7" length="12" decimal_digits="0" nullable="1" is_nullable="YES" />
<column name="COSTOPRI" remarks="" type_name="float" data_type="7" length="12" decimal_digits="0" nullable="1" is_nullable="YES" />
<column name="IDORIGEN" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="IDDESTINO" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
</columns>
<primaryKeys>
<column name="IdRuta" position="1" />
</primaryKeys>
<foreingKeys>
<fkTable fkTableName="aeropuerto" pkTableName="RUTA">
<pkColumn pkColumnName="idDestino" fkColumnName="IdAeropuerto" KeySecuence="1" updateRule="importedKeyCascade" deleteRule="importedKeyCascade" deferrability="importedKeyNotDeferrable" />
</fkTable>
<fkTable fkTableName="aeropuerto" pkTableName="RUTA">
<pkColumn pkColumnName="idOrigen" fkColumnName="IdAeropuerto" KeySecuence="1" updateRule="importedKeyCascade" deleteRule="importedKeyCascade" deferrability="importedKeyNotDeferrable" />
</fkTable>
</foreingKeys>
</table>
<table name="UNIDAD" type="TABLE" table_cat="test" remarks="">
<columns>
<column name="IDUNIDAD" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="IDMODELO" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="1" is_nullable="YES" />
</columns>
<primaryKeys>
<column name="IdUnidad" position="1" />
</primaryKeys>
<foreingKeys>
<fkTable fkTableName="modelo" pkTableName="UNIDAD">
<pkColumn pkColumnName="IdModelo" fkColumnName="IdModelo" KeySecuence="1" updateRule="importedKeyCascade" deleteRule="importedKeyCascade" deferrability="importedKeyNotDeferrable" />
</fkTable>
</foreingKeys>
</table>
<table name="VUELO" type="TABLE" table_cat="test" remarks="">
<columns>
<column name="IDVUELO" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="FDESPEGUE" remarks="" type_name="datetime" data_type="93" length="19" decimal_digits="0" nullable="1" is_nullable="YES" />
<column name="IDRUTA" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="IDUNIDAD" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
</columns>
<primaryKeys>
<column name="IdVuelo" position="1" />
</primaryKeys>
<foreingKeys>
<fkTable fkTableName="ruta" pkTableName="VUELO">
<pkColumn pkColumnName="idRuta" fkColumnName="IdRuta" KeySecuence="1" updateRule="importedKeyCascade" deleteRule="importedKeyCascade" deferrability="importedKeyNotDeferrable" />
</fkTable>
<fkTable fkTableName="unidad" pkTableName="VUELO">
<pkColumn pkColumnName="idUnidad" fkColumnName="IdUnidad" KeySecuence="1" updateRule="importedKeyCascade" deleteRule="importedKeyCascade" deferrability="importedKeyNotDeferrable" />
</fkTable>
</foreingKeys>
</table>
</tables>
</DatabaseSchema>
<Connection driver="com.mysql.jdbc.Driver" user="test">
jdbc:mysql://localhost:3306/test?zeroDateTimeBehavior=convertToNull
<Catalogs>
<Catalog>information_schema</Catalog>
<Catalog>test</Catalog>
</Catalogs>
<Schemas />
<TableTypes />
</Connection>
<DataTypes>
<type type_name="BIT" data_type="-7" precision="1" literal_prefix="" literal_suffix="" create_paramsS="" nullable="1" case_sensitive="true" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="BIT" minimum_scale="0" maximum_scale="0" />
<type type_name="BOOL" data_type="-7" precision="1" literal_prefix="" literal_suffix="" create_paramsS="" nullable="1" case_sensitive="true" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="BOOL" minimum_scale="0" maximum_scale="0" />
<type type_name="TINYINT" data_type="-6" precision="3" literal_prefix="" literal_suffix="" create_paramsS="[(M)] [UNSIGNED] [ZEROFILL]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="true" auto_increment="true" local_type_name="TINYINT" minimum_scale="0" maximum_scale="0" />
<type type_name="BIGINT" data_type="-5" precision="19" literal_prefix="" literal_suffix="" create_paramsS="[(M)] [UNSIGNED] [ZEROFILL]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="true" auto_increment="true" local_type_name="BIGINT" minimum_scale="0" maximum_scale="0" />
<type type_name="LONG VARBINARY" data_type="-4" precision="16777215" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="true" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="LONG VARBINARY" minimum_scale="0" maximum_scale="0" />
<type type_name="MEDIUMBLOB" data_type="-4" precision="16777215" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="true" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="MEDIUMBLOB" minimum_scale="0" maximum_scale="0" />
<type type_name="LONGBLOB" data_type="-4" precision="2147483647" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="true" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="LONGBLOB" minimum_scale="0" maximum_scale="0" />
<type type_name="BLOB" data_type="-4" precision="65535" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="true" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="BLOB" minimum_scale="0" maximum_scale="0" />
<type type_name="TINYBLOB" data_type="-4" precision="255" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="true" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="TINYBLOB" minimum_scale="0" maximum_scale="0" />
<type type_name="VARBINARY" data_type="-3" precision="255" literal_prefix="'" literal_suffix="'" create_paramsS="(M)" nullable="1" case_sensitive="true" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="VARBINARY" minimum_scale="0" maximum_scale="0" />
<type type_name="BINARY" data_type="-2" precision="255" literal_prefix="'" literal_suffix="'" create_paramsS="(M)" nullable="1" case_sensitive="true" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="BINARY" minimum_scale="0" maximum_scale="0" />
<type type_name="LONG VARCHAR" data_type="-1" precision="16777215" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="LONG VARCHAR" minimum_scale="0" maximum_scale="0" />
<type type_name="MEDIUMTEXT" data_type="-1" precision="16777215" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="MEDIUMTEXT" minimum_scale="0" maximum_scale="0" />
<type type_name="LONGTEXT" data_type="-1" precision="2147483647" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="LONGTEXT" minimum_scale="0" maximum_scale="0" />
<type type_name="TEXT" data_type="-1" precision="65535" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="TEXT" minimum_scale="0" maximum_scale="0" />
<type type_name="TINYTEXT" data_type="-1" precision="255" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="TINYTEXT" minimum_scale="0" maximum_scale="0" />
<type type_name="CHAR" data_type="1" precision="255" literal_prefix="'" literal_suffix="'" create_paramsS="(M)" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="CHAR" minimum_scale="0" maximum_scale="0" />
<type type_name="NUMERIC" data_type="2" precision="17" literal_prefix="" literal_suffix="" create_paramsS="[(M[,D])] [ZEROFILL]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="true" local_type_name="NUMERIC" minimum_scale="-308" maximum_scale="308" />
<type type_name="DECIMAL" data_type="3" precision="17" literal_prefix="" literal_suffix="" create_paramsS="[(M[,D])] [ZEROFILL]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="true" local_type_name="DECIMAL" minimum_scale="-308" maximum_scale="308" />
<type type_name="INTEGER" data_type="4" precision="10" literal_prefix="" literal_suffix="" create_paramsS="[(M)] [UNSIGNED] [ZEROFILL]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="true" auto_increment="true" local_type_name="INTEGER" minimum_scale="0" maximum_scale="0" />
<type type_name="INT" data_type="4" precision="10" literal_prefix="" literal_suffix="" create_paramsS="[(M)] [UNSIGNED] [ZEROFILL]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="true" auto_increment="true" local_type_name="INT" minimum_scale="0" maximum_scale="0" />
<type type_name="MEDIUMINT" data_type="4" precision="7" literal_prefix="" literal_suffix="" create_paramsS="[(M)] [UNSIGNED] [ZEROFILL]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="true" auto_increment="true" local_type_name="MEDIUMINT" minimum_scale="0" maximum_scale="0" />
<type type_name="SMALLINT" data_type="5" precision="5" literal_prefix="" literal_suffix="" create_paramsS="[(M)] [UNSIGNED] [ZEROFILL]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="true" auto_increment="true" local_type_name="SMALLINT" minimum_scale="0" maximum_scale="0" />
<type type_name="FLOAT" data_type="7" precision="10" literal_prefix="" literal_suffix="" create_paramsS="[(M,D)] [ZEROFILL]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="true" local_type_name="FLOAT" minimum_scale="-38" maximum_scale="38" />
<type type_name="DOUBLE" data_type="8" precision="17" literal_prefix="" literal_suffix="" create_paramsS="[(M,D)] [ZEROFILL]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="true" local_type_name="DOUBLE" minimum_scale="-308" maximum_scale="308" />
<type type_name="DOUBLE PRECISION" data_type="8" precision="17" literal_prefix="" literal_suffix="" create_paramsS="[(M,D)] [ZEROFILL]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="true" local_type_name="DOUBLE PRECISION" minimum_scale="-308" maximum_scale="308" />
<type type_name="REAL" data_type="8" precision="17" literal_prefix="" literal_suffix="" create_paramsS="[(M,D)] [ZEROFILL]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="true" local_type_name="REAL" minimum_scale="-308" maximum_scale="308" />
<type type_name="VARCHAR" data_type="12" precision="255" literal_prefix="'" literal_suffix="'" create_paramsS="(M)" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="VARCHAR" minimum_scale="0" maximum_scale="0" />
<type type_name="ENUM" data_type="12" precision="65535" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="ENUM" minimum_scale="0" maximum_scale="0" />
<type type_name="SET" data_type="12" precision="64" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="SET" minimum_scale="0" maximum_scale="0" />
<type type_name="DATE" data_type="91" precision="0" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="DATE" minimum_scale="0" maximum_scale="0" />
<type type_name="TIME" data_type="92" precision="0" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="TIME" minimum_scale="0" maximum_scale="0" />
<type type_name="DATETIME" data_type="93" precision="0" literal_prefix="'" literal_suffix="'" create_paramsS="" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="DATETIME" minimum_scale="0" maximum_scale="0" />
<type type_name="TIMESTAMP" data_type="93" precision="0" literal_prefix="'" literal_suffix="'" create_paramsS="[(M)]" nullable="1" case_sensitive="false" searchable="3" unsigned_attribute="false" auto_increment="false" local_type_name="TIMESTAMP" minimum_scale="0" maximum_scale="0" />
</DataTypes>
<tables>
<table name="AEROPUERTO" type="TABLE" table_cat="test" remarks="">
<columns>
<column name="IDAEROPUERTO" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="NOMBREA" remarks="" type_name="varchar" data_type="12" length="50" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="CIUDADA" remarks="" type_name="varchar" data_type="12" length="20" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="ESTADOA" remarks="" type_name="varchar" data_type="12" length="20" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="PAISA" remarks="" type_name="varchar" data_type="12" length="25" decimal_digits="0" nullable="1" is_nullable="YES" />
</columns>
<primaryKeys>
<column name="IdAeropuerto" position="1" />
</primaryKeys>
<foreingKeys />
</table>
<table name="BOLETO" type="TABLE" table_cat="test" remarks="">
<columns>
<column name="IDBOLETO" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="TIPOBOLETO" remarks="" type_name="enum" data_type="1" length="2" decimal_digits="0" nullable="1" is_nullable="YES" />
<column name="IDCLIENTE" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="IDVUELO" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
</columns>
<primaryKeys>
<column name="IdBoleto" position="1" />
</primaryKeys>
<foreingKeys>
<fkTable fkTableName="cliente" pkTableName="BOLETO">
<pkColumn pkColumnName="IdCliente" fkColumnName="IdCliente" KeySecuence="1" updateRule="importedKeyCascade" deleteRule="importedKeyCascade" deferrability="importedKeyNotDeferrable" />
</fkTable>
<fkTable fkTableName="vuelo" pkTableName="BOLETO">
<pkColumn pkColumnName="IdVuelo" fkColumnName="IdVuelo" KeySecuence="1" updateRule="importedKeyCascade" deleteRule="importedKeyCascade" deferrability="importedKeyNotDeferrable" />
</fkTable>
</foreingKeys>
</table>
<table name="CLIENTE" type="TABLE" table_cat="test" remarks="">
<columns>
<column name="IDCLIENTE" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="CURP" remarks="" type_name="varchar" data_type="12" length="18" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="NOMBRE" remarks="" type_name="varchar" data_type="12" length="20" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="APEPAT" remarks="" type_name="varchar" data_type="12" length="20" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="APEMAT" remarks="" type_name="varchar" data_type="12" length="20" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="TEL" remarks="" type_name="varchar" data_type="12" length="10" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="SEXO" remarks="" type_name="enum" data_type="1" length="2" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="PASAPORTE" remarks="" type_name="varchar" data_type="12" length="11" decimal_digits="0" nullable="1" is_nullable="YES" />
</columns>
<primaryKeys>
<column name="IdCliente" position="1" />
</primaryKeys>
<foreingKeys />
</table>
<table name="DIRECCION" type="TABLE" table_cat="test" remarks="">
<columns>
<column name="IDDIRECCION" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="CALLE" remarks="" type_name="varchar" data_type="12" length="20" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="NUMEXT" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="NUMINT" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="COLONIA" remarks="" type_name="varchar" data_type="12" length="20" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="MUNICIPIO" remarks="" type_name="varchar" data_type="12" length="20" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="ESTADO" remarks="" type_name="varchar" data_type="12" length="20" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="CP" remarks="" type_name="varchar" data_type="12" length="5" decimal_digits="0" nullable="1" is_nullable="YES" />
<column name="IDCLIENTE" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="1" is_nullable="YES" />
</columns>
<primaryKeys>
<column name="IdDireccion" position="1" />
</primaryKeys>
<foreingKeys>
<fkTable fkTableName="cliente" pkTableName="DIRECCION">
<pkColumn pkColumnName="IdCliente" fkColumnName="IdCliente" KeySecuence="1" updateRule="importedKeyCascade" deleteRule="importedKeyCascade" deferrability="importedKeyNotDeferrable" />
</fkTable>
</foreingKeys>
</table>
<table name="MODELO" type="TABLE" table_cat="test" remarks="">
<columns>
<column name="IDMODELO" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="DISPTUR" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="1" is_nullable="YES" />
<column name="DISPPRI" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="1" is_nullable="YES" />
</columns>
<primaryKeys>
<column name="IdModelo" position="1" />
</primaryKeys>
<foreingKeys />
</table>
<table name="RUTA" type="TABLE" table_cat="test" remarks="">
<columns>
<column name="IDRUTA" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="DURACION" remarks="" type_name="float" data_type="7" length="12" decimal_digits="0" nullable="1" is_nullable="YES" />
<column name="COSTOTUR" remarks="" type_name="float" data_type="7" length="12" decimal_digits="0" nullable="1" is_nullable="YES" />
<column name="COSTOPRI" remarks="" type_name="float" data_type="7" length="12" decimal_digits="0" nullable="1" is_nullable="YES" />
<column name="IDORIGEN" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="IDDESTINO" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
</columns>
<primaryKeys>
<column name="IdRuta" position="1" />
</primaryKeys>
<foreingKeys>
<fkTable fkTableName="aeropuerto" pkTableName="RUTA">
<pkColumn pkColumnName="idDestino" fkColumnName="IdAeropuerto" KeySecuence="1" updateRule="importedKeyCascade" deleteRule="importedKeyCascade" deferrability="importedKeyNotDeferrable" />
</fkTable>
<fkTable fkTableName="aeropuerto" pkTableName="RUTA">
<pkColumn pkColumnName="idOrigen" fkColumnName="IdAeropuerto" KeySecuence="1" updateRule="importedKeyCascade" deleteRule="importedKeyCascade" deferrability="importedKeyNotDeferrable" />
</fkTable>
</foreingKeys>
</table>
<table name="UNIDAD" type="TABLE" table_cat="test" remarks="">
<columns>
<column name="IDUNIDAD" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="IDMODELO" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="1" is_nullable="YES" />
</columns>
<primaryKeys>
<column name="IdUnidad" position="1" />
</primaryKeys>
<foreingKeys>
<fkTable fkTableName="modelo" pkTableName="UNIDAD">
<pkColumn pkColumnName="IdModelo" fkColumnName="IdModelo" KeySecuence="1" updateRule="importedKeyCascade" deleteRule="importedKeyCascade" deferrability="importedKeyNotDeferrable" />
</fkTable>
</foreingKeys>
</table>
<table name="VUELO" type="TABLE" table_cat="test" remarks="">
<columns>
<column name="IDVUELO" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="FDESPEGUE" remarks="" type_name="datetime" data_type="93" length="19" decimal_digits="0" nullable="1" is_nullable="YES" />
<column name="IDRUTA" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
<column name="IDUNIDAD" remarks="" type_name="int" data_type="4" length="11" decimal_digits="0" nullable="0" is_nullable="NO" />
</columns>
<primaryKeys>
<column name="IdVuelo" position="1" />
</primaryKeys>
<foreingKeys>
<fkTable fkTableName="ruta" pkTableName="VUELO">
<pkColumn pkColumnName="idRuta" fkColumnName="IdRuta" KeySecuence="1" updateRule="importedKeyCascade" deleteRule="importedKeyCascade" deferrability="importedKeyNotDeferrable" />
</fkTable>
<fkTable fkTableName="unidad" pkTableName="VUELO">
<pkColumn pkColumnName="idUnidad" fkColumnName="IdUnidad" KeySecuence="1" updateRule="importedKeyCascade" deleteRule="importedKeyCascade" deferrability="importedKeyNotDeferrable" />
</fkTable>
</foreingKeys>
</table>
</tables>
</DatabaseSchema>
And the next html file
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Left frame</title>
<script type="text/javascript" src="Backbase_4_1/engine/boot.js"></script>
<script xmlns:xi="http://www.w3.org/2001/XInclude" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" type="text/backbase+xml">
<xi:include href="Backbase_4_1/tools/debugger/debugger.xml" />
</script>
<style type="text/css">
.panelset-layout {border: 1px solid black; position: absolute; left: 0px; top: 0px; width: 100%; height: 100%; }
.panel-layout {border: 1px solid black; padding: 12px; height: 500px;}
.style1 {
font-family: Arial, Helvetica, sans-serif;
font-weight: bold;
}
.style2 {
font-size: 24px
}
</style>
</head>
<body>
<script xmlns="http://www.w3.org/1999/xhtml"
xmlns:smil="http://www.w3.org/2005/SMIL21"
xmlns:xi="http://www.w3.org/2001/XInclude"
xmlns:b="http://www.backbase.com/2006/btl"
xmlns:e="http://www.backbase.com/2006/xel"
xmlns:c="http://www.backbase.com/2006/command" type="application/backbase+xml">
<xi:include href="Backbase_4_1/tools/debugger/debugger.xml" />
<xi:include href="Backbase_4_1/bindings/config.xml" />
<!--Data source para mostrar las tablas disponibles-->
<b:dataSource name="myData" e:behavior="b:remoteData" url="myTest.xml" dataType="application/xml" />
<div class="panelset-layout">
<b:panelSet columns="200px *" splitter="true">
<b:panel width="200px;" height="500px">
<div id="left_side_content" />
<!--Llenamos grid de tablas-->
<b:listGrid dataSource="myData" readonly="true" width="100%" height="250px" rowClasses="rowClass1, rowClass2" id="listGrid">
<b:listGridCol select="//tables/table/@name" label="Título" display="true">
</b:listGridCol>
</b:listGrid>
</b:panel>
<b:panel width="100%;" height="500px">
<div id="right_side_content" />
</b:panel>
</b:panelSet> <!--Cerramos el panel set-->
</div>
</script>
</body>
</html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Left frame</title>
<script type="text/javascript" src="Backbase_4_1/engine/boot.js"></script>
<script xmlns:xi="http://www.w3.org/2001/XInclude" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" type="text/backbase+xml">
<xi:include href="Backbase_4_1/tools/debugger/debugger.xml" />
</script>
<style type="text/css">
.panelset-layout {border: 1px solid black; position: absolute; left: 0px; top: 0px; width: 100%; height: 100%; }
.panel-layout {border: 1px solid black; padding: 12px; height: 500px;}
.style1 {
font-family: Arial, Helvetica, sans-serif;
font-weight: bold;
}
.style2 {
font-size: 24px
}
</style>
</head>
<body>
<script xmlns="http://www.w3.org/1999/xhtml"
xmlns:smil="http://www.w3.org/2005/SMIL21"
xmlns:xi="http://www.w3.org/2001/XInclude"
xmlns:b="http://www.backbase.com/2006/btl"
xmlns:e="http://www.backbase.com/2006/xel"
xmlns:c="http://www.backbase.com/2006/command" type="application/backbase+xml">
<xi:include href="Backbase_4_1/tools/debugger/debugger.xml" />
<xi:include href="Backbase_4_1/bindings/config.xml" />
<!--Data source para mostrar las tablas disponibles-->
<b:dataSource name="myData" e:behavior="b:remoteData" url="myTest.xml" dataType="application/xml" />
<div class="panelset-layout">
<b:panelSet columns="200px *" splitter="true">
<b:panel width="200px;" height="500px">
<div id="left_side_content" />
<!--Llenamos grid de tablas-->
<b:listGrid dataSource="myData" readonly="true" width="100%" height="250px" rowClasses="rowClass1, rowClass2" id="listGrid">
<b:listGridCol select="//tables/table/@name" label="Título" display="true">
</b:listGridCol>
</b:listGrid>
</b:panel>
<b:panel width="100%;" height="500px">
<div id="right_side_content" />
</b:panel>
</b:panelSet> <!--Cerramos el panel set-->
</div>
</script>
</body>
</html>
As you can see, I'm trying to get a list of all the attributes "name", but the result of the query is that I only get three rows "AEROPUERTO". Also, I get the same result with the next query:
<b:listGridCol select="//@name" label="Título" display="true">
Can someone help me, please?
By the way, if I try to execute the code above using IE 6.0 nothing is displayed (I'm using Firefox 2.0 and Windows XP).
Hi phreakermex, The reason
28 December, 2007 - 14:25 — GrauwHi phreakermex,
The reason why you’re getting three results is because the data binding system considers each child element of the root element a record, and in your XML document, the DatabaseSchema element has three child elements (Connection, DataTypes and tables). The query is evaluated for each of those records, which results in the same value every time.
Your best option right now is, I think, to modify your XML file to have the tables element as root node. Alternatively, you could use the b:localData behavior where you can specify a root element path in the dataSelect attribute. Or, if you’re feeling adventurous, you could hack in support for a records selector in b:remoteData.
As for your IE6 trouble, at least in my IE7 everything shows up (albeit with some rendering errors). To avoid rendering issues in Internet Explorer you need to make sure it’s running in quirks (border-box) mode by adding a comment at the top of your HTML document:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
Another thing, it’s usually best to avoid the // selector, because that evaluates every node in the document, which can be slow. So instead of:
It’s better to use:
Hope that helps,
~Grauw