maravilloso

SELECT
    CAST(t.tabname AS VARCHAR(15)) AS tabla,
    CAST(colname AS VARCHAR(15)) AS campo,
    CASE
        WHEN coltype >= 256 THEN cast(coltype-256 AS VARCHAR(4))
        ELSE cast(coltype AS VARCHAR(4))
    END AS tipo,
    collength AS lon
FROM syscolumns c, systables t
WHERE c.tabid=t.tabid AND t.tabname[1,2]='fa'

maravilloso

SELECT CAST(a.tabname AS VARCHAR(15)) AS tabla,
        CAST(constrname AS VARCHAR(20)) AS FK,
        CAST(d.tabname AS VARCHAR(15)) AS referenciada,
        delrule
  FROM systables a, sysconstraints b, sysreferences c,
       systables d
 WHERE b.constrtype = 'R'
   AND a.tabid = b.tabid
   AND b.constrid = c.constrid
   AND c.ptabid = d.tabid

maravilloso

SELECT FIRST 1 DBSERVERNAME, DBINFO('dbhostname') FROM systables
-- Devolvera algo como "ids_inst6" "willy"

maravilloso

SELECT tabname, fextsize, nextsize FROM systables WHERE tabid >= 100;

maravilloso

SELECT FIRST 1 DBINFO('version', 'major')||'.'||DBINFO('version', 'minor')
FROM systables

maravilloso

<IMG SRC="data:image/gif;base64,RAAAtuhhx4dbgYKAAA7...more data....." ALT="Larry">

maravilloso

new net.sf.jasperreports.engine.data.JRXlsDataSource(
    new File("E:/proyectos/TSE/src/Jasper/proto1.xls")
)

maravilloso

<import value="javax.imageio.ImageIO"/>
<import value="org.apache.commons.codec.binary.Base64"/>

maravilloso

Syntax               Description
===================  ======================================================
$F{name_field}       Specifies the name_field field ("F" means field).
$V{name_variable}    Specifies the name_ variable variable.
$P{name_parameter}   Specifies the name_parameter parameter.
$P!{name_parameter}  Special syntax used in the report SQL query to indicate that the parameter
                     does not have to be dealt as a value to transfer to a prepared statement,
                     but that it represents a little piece of the query.
$R{resource_key}     Special syntax for localization of strings.
$X{op, field, param} For dynamic [NOT] IN clauses. See bellow:

maravilloso

ioPARAMS.put(JRParameter.REPORT_LOCALE, new Locale("es", "ES"));