Histórico da Página

  TRANSLATE: SELECT informix.schema_coltypename(c.coltype, c.extended_id) coltype,                 
                    c.collength,                 
                    informix.schema_precision(c.coltype, c.extended_id, c.collength) precision,                 
                    0 numscale,                 
                    DECODE(BITAND(coltype,256), 256, 'S', 'N') isnullable                       
               FROM syscolumns c            JOIN systables t ON c.tabid = t.tabid           
              WHERE c.coltype NOT IN (10, 14, 266, 270)             
                AND c.colname = ?             
                AND t.tabname = ?           
              UNION          
             SELECT informix.schema_coltypename(c.coltype, c.extended_id) coltype,                 
                    c.collength,                 
                    (MOD(MOD(c.collength,256),16)) precision,                 
                    ((MOD(c.collength,256) - (MOD(MOD(c.collength,256),16)) ) / 16) scale,                 
                    DECODE(BITAND(coltype,256), 256, 'S', 'N') isnullable            
               INTO ?, ?, ?, ?, ?            
               FROM syscolumns c            JOIN systables t ON c.tabid = t.tabid           
              WHERE c.coltype IN (10, 14, 266, 270)             
                AND c.colname = ?             
                AND t.tabname = ?
  SQLBLOCK
  RUNNING TIME: 0.002
  4GL SOURCE: DBINFO.4GL  LINE: 185 
  STATUS: -201   TRANSACTION: FALSE SID:168969
  ISAM: -201
  MSG: A syntax error has occurred.