Application: gvSIG desktop

                table.schema(builderTable.getSchema());

            }

            String tableName = table.getName();

            if (StringUtils.equalsIgnoreCase(builderTableName, tableName)) {

                featureType = (FeatureType) builder.getProperty(SQLBuilder.PROP_FEATURE_TYPE);

                DataManager dataManager = DALLocator.getDataManager();

                featureType = dataManager.getStoresRepository().getFeatureType(tableName);

            }

                        select.column().value(builder.constant(null));

                    } else if (column instanceof Code.Identifier) {

                        String columnName = ((Code.Identifier) column).name();

                            select.column().name(table,columnName);

                    } else {

                        select.column().value(setTableName(table, column.toValue(builder)));

                    }

                    SQLBuilder.Column c = (SQLBuilder.Column) value;

                    SQLBuilder.TableNameBuilder t = c.table();

                    if( t==null ) {

                            c.table(table);

                        }

                        return;

       "PUBLIC"."test"."Bool5",

       "PUBLIC"."test"."Decimal",

       NVL2("PUBLIC"."test"."Geometry",ST_AsBinary("PUBLIC"."test"."Geometry"),NULL),

FROM "PUBLIC"."test"

                    FROM "PUBLIC"."countries"

                    WHERE (("PUBLIC"."test"."STRING" = "PUBLIC"."countries"."CONTINENT") AND ("PUBLIC"."countries"."LASTCENSUS" < 0))

                    LIMIT 1 )),TRUE,FALSE)

        StringBuilder filter = new StringBuilder();

        filter.append("EXISTS(");

        filter.append(" SELECT \"Long\" FROM countries");

//        filter.append(" SELECT \"Long\", \"CONTINENT\" FROM countries");

        filter.append("   WHERE ");

        filter.append("     test.STRING = countries.CONTINENT AND ");

       "test"."Bool5",

       "test"."Decimal",

       "test"."Geometry",

FROM "test"

                    FROM "countries"

                    WHERE (("test"."STRING" = "countries"."CONTINENT") AND ("countries"."LASTCENSUS" < 0))

                    LIMIT 1 )