SQL: CONNECT TO "decomarmol" USER "lmsoto" USING "***" | 4gl source : credenciales.4gl line=36 | loading driver : [/home/fourjs/fgl/dbdrivers/dbmsnc_17] | snc.c:00346(3) : Multibyte CMAX : 6 | db driver type : snc | snc.c:00409(3) : Connection parameters for 'decomarmol': | snc.c:00410(3) : ODBC Data source = 'decomarmol' | snc.c:00411(3) : User name = 'lmsoto' | snc.c:00412(3) : Password = '*' | snc.c:00413(3) : Login timeout = 'default' | snc.c:00414(3) : Prefetch rows = 'default' | snc.c:00423(3) : Use Wide Chars = 'yes' | ../ODI_common_msv.h:00363(3) : Diagnostic info: | ../ODI_common_msv.h:00364(3) : SQL State: 01000 | ../ODI_common_msv.h:00365(3) : SQL code : 5701 | ../ODI_common_msv.h:00366(3) : Message : [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Changed database context to 'decomarmol_old'. | snc.c:00526(3) : ODBC Driver = 'libmsodbcsql-17.9.so.1.1' | ../ODI_common_msv.h:00071(1) : Server version = 15.0.4236.7 | ../ODI_common_msv.h:00072(1) : DB Compat version= 150 | ../ODI_common_msv.h:00083(1) : Normalized vers. = 1500 | ../ODI_common.h:00501(3) : ODI_Connect: ifxemul = 1 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | Execution time : 0 00:00:00.01908 SQL: SELECT a.cod_perfil, a.printerdefecto, a.otro_printer, a.printer_cheque, a.cambia_clave, a.cod_cia FROM seg0001 a WHERE a.usuario = ? | 4gl source : credenciales.4gl line=41 | ../ODI_common.h:00795(3) : adaptStatement: stmt type = 1 | ../ODI_common.h:00800(3) : adaptStatement: ifxemul = 1 | ../ODI_common_msv.h:01388(3) : Nat stmt1 = select a.cod_perfil, a.printerdefecto, a.otro_printer, a.printer_cheque, a.cambia_clave, a.cod_cia from seg0001 a where a.usuario = ? | ../ODI_common_msv.h:01254(3) : Fetch array size = 10 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | using: 1 | t: VARCHAR(50) f:01 v:"lmsoto" | into: 6 | t: INTEGER f:04 v:"99" | t: INTEGER f:04 v:"10" | t: INTEGER f:04 v:"10" | t: INTEGER f:04 v:"10" | t: VARCHAR(10) f:04 v:"NO" | t: INTEGER f:04 v:"" | Execution time : 0 00:00:00.00109 SQL: UPDATE seg0001 SET seg0001.fecha_ultimo_login = getdate(),seg0001.clave = ? WHERE seg0001.usuario = ? | 4gl source : credenciales.4gl line=49 | ../ODI_common.h:00795(3) : adaptStatement: stmt type = 3 | ../ODI_common.h:00800(3) : adaptStatement: ifxemul = 1 | ../ODI_common_msv.h:01388(3) : Nat stmt1 = update seg0001 SET seg0001.fecha_ultimo_login = getdate(),seg0001.clave = ? WHERE seg0001.usuario = ? | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | using: 2 | t: VARCHAR(50) f:01 v:"Lm5798379" | t: VARCHAR(50) f:01 v:"lmsoto" | Execution time : 0 00:00:00.00131 SQL: SELECT a.nombre, a.url FROM companias a WHERE a.cod_comp = ? | 4gl source : demo.4gl line=45 | ../ODI_common.h:00795(3) : adaptStatement: stmt type = 1 | ../ODI_common.h:00800(3) : adaptStatement: ifxemul = 1 | ../ODI_common_msv.h:01388(3) : Nat stmt1 = select a.nombre, a.url from companias a where a.cod_comp = ? | ../ODI_common_msv.h:01254(3) : Fetch array size = 10 | sqlcode : 100 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | using: 1 | t: INTEGER f:01 v:"" | into: 2 | t: STRING f:04 v:"" | t: STRING f:04 v:"" | Execution time : 0 00:00:00.00090 SQL: SELECT a.nombre FROM companias a | 4gl source : demo.4gl line=51 | ../ODI_common.h:00795(3) : adaptStatement: stmt type = 1 | ../ODI_common.h:00800(3) : adaptStatement: ifxemul = 1 | ../ODI_common_msv.h:01388(3) : Nat stmt1 = select a.nombre from companias a | ../ODI_common_msv.h:01254(3) : Fetch array size = 10 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | into: 1 | t: STRING f:04 v:"Decomarmol Piedras y Granitos" | Execution time : 0 00:00:00.00060 SQL: SELECT a.prima FROM vetb00019 a WHERE disponible = 'S' | 4gl source : demo.4gl line=52 | ../ODI_common.h:00795(3) : adaptStatement: stmt type = 1 | ../ODI_common.h:00800(3) : adaptStatement: ifxemul = 1 | ../ODI_common_msv.h:01388(3) : Nat stmt1 = select a.prima from vetb00019 a where disponible = N'S' | ../ODI_common_msv.h:01254(3) : Fetch array size = 10 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | into: 1 | t: FLOAT f:04 v:"50.0" | Execution time : 0 00:00:00.00074 SQL: DECLARE | 4gl source : demo.4gl line=143 | ../ODI_common.h:00795(3) : adaptStatement: stmt type = 1 | ../ODI_common.h:00800(3) : adaptStatement: ifxemul = 1 | ../ODI_common_msv.h:01388(3) : Nat stmt1 = select a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio from topics a where a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' order by orden,parent,nombre | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | scroll cursor : 0 | with hold : 0 | Execution time : 0 00:00:00.00034 SQL: OPEN | 4gl source : demo.4gl line=154 | ../ODI_common_msv.h:01254(3) : Fetch array size = 10 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | Execution time : 0 00:00:00.00253 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"CONTABILIDAD GENERAL" | t: VARCHAR(255) f:04 v:"" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00041 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"CONTABILIDAD GENERAL" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/Mantenimientos" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Anular Cheques" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/Mantenimientos" | t: VARCHAR(50) f:04 v:"cgprmt015" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Cheques Administrativos RD$" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/Mantenimientos" | t: VARCHAR(50) f:04 v:"cgprmt005" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Conciliacion Bancarias" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/Mantenimientos" | t: VARCHAR(50) f:04 v:"cgprmt011" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Entradas al diario" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/Mantenimientos" | t: VARCHAR(50) f:04 v:"cgprmt004" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Gestion Catalogo de cuentas" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/Mantenimientos" | t: VARCHAR(50) f:04 v:"cgprmt001" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Maestra De Bancos" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/Mantenimientos" | t: VARCHAR(50) f:04 v:"cgprmt014" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Periodos fiscales" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/Mantenimientos" | t: VARCHAR(50) f:04 v:"prd00000" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"TRANSFERENCIAS" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/Mantenimientos" | t: VARCHAR(50) f:04 v:"cgprmt017" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Consultas" | t: VARCHAR(255) f:04 v:"CONTABILIDAD GENERAL" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/consultas" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00032 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"CHEQUES" | t: VARCHAR(255) f:04 v:"Consultas" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/Consultas" | t: VARCHAR(50) f:04 v:"cgprcs001" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Transacciones" | t: VARCHAR(255) f:04 v:"Consultas" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/consultas" | t: VARCHAR(50) f:04 v:"cgprcs002" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"CONTABILIDAD GENERAL" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/reportes" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Analisis Gastos x Dpto." | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/reportes" | t: VARCHAR(50) f:04 v:"cgprrp009" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Catalogo de Cuentas" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/reportes" | t: VARCHAR(50) f:04 v:"cgprrp001" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Chques nulos" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/Reportes" | t: VARCHAR(50) f:04 v:"cgprrp019" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Diario General" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/reportes" | t: VARCHAR(50) f:04 v:"cgprrp005" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Entradas Registradas" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/reportes" | t: VARCHAR(50) f:04 v:"cgprrp022" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Estados Financieros" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/reportes" | t: VARCHAR(50) f:04 v:"cgprrp012" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Mayor Detallado x Refer" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/reportes" | t: VARCHAR(50) f:04 v:"cgprrp014" | Execution time : 0 00:00:00.00034 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Mayor General" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/reportes" | t: VARCHAR(50) f:04 v:"cgprrp015" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Mayor General Analitico" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/reportes" | t: VARCHAR(50) f:04 v:"cgprrp008" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Relacion cheques Cancelados" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/Reportes" | t: VARCHAR(50) f:04 v:"cgprrp018" | Execution time : 0 00:00:00.00010 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Relacion Cheques Emitidos" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/Reportes" | t: VARCHAR(50) f:04 v:"cgprrp023" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Relacion Cheques En Transitos" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CONTABILIDAD/Reportes" | t: VARCHAR(50) f:04 v:"cgprrp017" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"PRODUCTOS TERMINADOS" | t: VARCHAR(255) f:04 v:"" | t: VARCHAR(255) f:04 v:"/PTOS" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"PRODUCTOS TERMINADOS" | t: VARCHAR(255) f:04 v:"/PTOS/Mantenimientos" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Anular Documentos" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/PTOS/Mantenimientos" | t: VARCHAR(50) f:04 v:"ipprmt064" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Catalogo Productos" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/PTOS/Mantenimientos" | t: VARCHAR(50) f:04 v:"ipprmt002" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Catalogo Tipos Movimientos" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/PTOS/Mantenimientos" | t: VARCHAR(50) f:04 v:"ipprmt003" | Execution time : 0 00:00:00.00030 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Clase" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/PTOS/Mantenimientos" | t: VARCHAR(50) f:04 v:"ipprmt005" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Color" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/PTOS/Mantenimientos" | t: VARCHAR(50) f:04 v:"ipprmt014" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Marcas" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/PTOS/Mantenimientos" | t: VARCHAR(50) f:04 v:"ipprmt012" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Modelos" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/PTOS/Mantenimientos" | t: VARCHAR(50) f:04 v:"ipprmt010" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Origen Producto" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/PTOS/Mantenimientos" | t: VARCHAR(50) f:04 v:"ipprmt004" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Productos Tienda Online" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/PTOS/Mantenimientos" | t: VARCHAR(50) f:04 v:"IPPRMT075" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Reporte Entradas productos" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/PTOS/Mantenimientos" | t: VARCHAR(50) f:04 v:"alprmt006" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Transacciones Inventario" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/PTOS/Mantenimientos" | t: VARCHAR(50) f:04 v:"ipprmt044" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Consultas" | t: VARCHAR(255) f:04 v:"PRODUCTOS TERMINADOS" | t: VARCHAR(255) f:04 v:"/PTOS/Consultas" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Balance Productos" | t: VARCHAR(255) f:04 v:"Consultas" | t: VARCHAR(255) f:04 v:"/PTOS/Consultas" | t: VARCHAR(50) f:04 v:"ipprcs006" | Execution time : 0 00:00:00.00031 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Existencia Productos" | t: VARCHAR(255) f:04 v:"Consultas" | t: VARCHAR(255) f:04 v:"/PTOS/Consultas" | t: VARCHAR(50) f:04 v:"ipprcs004" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Existencia Productos Con precios" | t: VARCHAR(255) f:04 v:"Consultas" | t: VARCHAR(255) f:04 v:"/PTOS/Consultas" | t: VARCHAR(50) f:04 v:"ipprcs004_1" | Execution time : 0 00:00:00.00009 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Hoja Vida Producto" | t: VARCHAR(255) f:04 v:"Consultas" | t: VARCHAR(255) f:04 v:"/PTOS/Consultas" | t: VARCHAR(50) f:04 v:"ipprcs042" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"PRODUCTOS TERMINADOS" | t: VARCHAR(255) f:04 v:"/PTOS/Reportes" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Catalogo Productos Terminados" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/PTOS/Reportes" | t: VARCHAR(50) f:04 v:"ipprrp002" | Execution time : 0 00:00:00.00008 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Dias de Inventario" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/PTOS/Reportes" | t: VARCHAR(50) f:04 v:"ipprrp013" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Existencia a Diferentes Fechas" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/PTOS/Reportes" | t: VARCHAR(50) f:04 v:"ipprrp009" | Execution time : 0 00:00:00.00008 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Existencias Con E/S" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/PTOS/Reportes" | t: VARCHAR(50) f:04 v:"ipprrp018" | Execution time : 0 00:00:00.00008 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Maestra Costo Standard" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/PTOS/Reportes" | t: VARCHAR(50) f:04 v:"ipprrp005" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Operacion Movimientos Detallado" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/PTOS/Reportes" | t: VARCHAR(50) f:04 v:"ipprrp010" | Execution time : 0 00:00:00.00031 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Productos Terminados Con Costos" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/PTOS/Reportes" | t: VARCHAR(50) f:04 v:"ipprrp002_1" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Reporte de productos por movimiento y departamentos" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/PTOS/Reportes" | t: VARCHAR(50) f:04 v:"ipprrp047" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Resumen Actividad de Mes" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/PTOS/Reportes" | t: VARCHAR(50) f:04 v:"ipprrp011" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Tipos de Movimientos" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/PTOS/Reportes" | t: VARCHAR(50) f:04 v:"ipprrp008" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Transacciones Productos Terminados" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/PTOS/Reportes" | t: VARCHAR(50) f:04 v:"ipprrp003" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"COMPRAS" | t: VARCHAR(255) f:04 v:"" | t: VARCHAR(255) f:04 v:"/compras" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"COMPRAS" | t: VARCHAR(255) f:04 v:"/compras/Mantenimientos" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Abrir y Cerrar Ordenes" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/compras/Mantenimientos" | t: VARCHAR(50) f:04 v:"coprmt015" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Monedas" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/compras/Mantenimientos" | t: VARCHAR(50) f:04 v:"coprmt019" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Ordenes de Compras" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/compras/Mantenimientos" | t: VARCHAR(50) f:04 v:"coprmt009" | Execution time : 0 00:00:00.00033 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Paises" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/compras/Mantenimientos" | t: VARCHAR(50) f:04 v:"coprmt010" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Puertos" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/compras/Mantenimientos" | t: VARCHAR(50) f:04 v:"coprmt011" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Suplidores" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/compras/Mantenimientos" | t: VARCHAR(50) f:04 v:"coprmt001" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Terminos de Pagos" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/compras/Mantenimientos" | t: VARCHAR(50) f:04 v:"coprmt016" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Consultas" | t: VARCHAR(255) f:04 v:"COMPRAS" | t: VARCHAR(255) f:04 v:"/compras/Consultas" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Bienes y Servicios Por Suplidor" | t: VARCHAR(255) f:04 v:"Consultas" | t: VARCHAR(255) f:04 v:"/compras/Consultas" | t: VARCHAR(50) f:04 v:"coprcs010" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Ordenes Bien y/o Servicios" | t: VARCHAR(255) f:04 v:"Consultas" | t: VARCHAR(255) f:04 v:"/compras/Consultas" | t: VARCHAR(50) f:04 v:"coprcs010" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Ordenes de Compras" | t: VARCHAR(255) f:04 v:"Consultas" | t: VARCHAR(255) f:04 v:"/compras/Consultas" | t: VARCHAR(50) f:04 v:"coprcs009" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"COMPRAS" | t: VARCHAR(255) f:04 v:"/compras/Reportes" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Catalogo Suplidores" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/compras/Reportes" | t: VARCHAR(50) f:04 v:"coprrp001" | Execution time : 0 00:00:00.00029 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Compra Por Suplidores" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/compras/Reportes" | t: VARCHAR(50) f:04 v:"coprrp029" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Compra y/o Servicios" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/compras/Reportes" | t: VARCHAR(50) f:04 v:"coprrp025" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Cronologico Ordenes" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/compras/Reportes" | t: VARCHAR(50) f:04 v:"coprrp004" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Ordenes Pendientes" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/compras/Reportes" | t: VARCHAR(50) f:04 v:"coprrp018" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Validacion Ordenes" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/compras/Reportes" | t: VARCHAR(50) f:04 v:"coprrp019" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Validacion Requisiciones" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/compras/Reportes" | t: VARCHAR(50) f:04 v:"coprrp007" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"CUENTAS POR PAGAR" | t: VARCHAR(255) f:04 v:"" | t: VARCHAR(255) f:04 v:"/CXP" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"CUENTAS POR PAGAR" | t: VARCHAR(255) f:04 v:"/CXP/Mantenimientos" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Facturas Proveedores" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/CXP/Mantenimientos" | t: VARCHAR(50) f:04 v:"cpprmt001" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Notas Debitos y Creditos" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/CXP/Mantenimientos" | t: VARCHAR(50) f:04 v:"cpprmt002" | Execution time : 0 00:00:00.00029 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Reclasificacion Facturas" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/CXP/Mantenimientos" | t: VARCHAR(50) f:04 v:"cgprmt011" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Consultas" | t: VARCHAR(255) f:04 v:"CUENTAS POR PAGAR" | t: VARCHAR(255) f:04 v:"/CXP/Consultas" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Estado Cuentas" | t: VARCHAR(255) f:04 v:"Consultas" | t: VARCHAR(255) f:04 v:"/CXP/Consultas" | t: VARCHAR(50) f:04 v:"cpprcs001" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Maestra Proveedores" | t: VARCHAR(255) f:04 v:"Consultas" | t: VARCHAR(255) f:04 v:"/CXP/Consultas" | t: VARCHAR(50) f:04 v:"cpprcs001" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"CUENTAS POR PAGAR" | t: VARCHAR(255) f:04 v:"/CXP/Reportes" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"606" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CXP/Reportes" | t: VARCHAR(50) f:04 v:"cpprrp018" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Analisis de Gastos por cuentas contables" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CXP/Reportes" | t: VARCHAR(50) f:04 v:"cpprrp013" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Analisis de Saldo Pendiente" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CXP/Reportes" | t: VARCHAR(50) f:04 v:"cpprrp006" | Execution time : 0 00:00:00.00010 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Estado Cuentas Proveedores" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CXP/Reportes" | t: VARCHAR(50) f:04 v:"cpprrp004" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Mayor Auxiliar" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CXP/Reportes" | t: VARCHAR(50) f:04 v:"cpprrp003" | Execution time : 0 00:00:00.00029 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Saldo por antiguedad" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CXP/Reportes" | t: VARCHAR(50) f:04 v:"cpprrp002" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Validacion Facturas Cuentas Contables" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CXP/Reportes" | t: VARCHAR(50) f:04 v:"cpprrp011" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Validacion Transacciones" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CXP/Reportes" | t: VARCHAR(50) f:04 v:"cpprrp001" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"LIQUIDACION MERCANCIAS" | t: VARCHAR(255) f:04 v:"" | t: VARCHAR(255) f:04 v:"/LIQ" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"LIQUIDACION MERCANCIAS" | t: VARCHAR(255) f:04 v:"/LIQ/Mantenimientos" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Liquidar Productoss" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/LIQ/Mantenimientos" | t: VARCHAR(50) f:04 v:"lqprmt001" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"LIQUIDACION MERCANCIAS" | t: VARCHAR(255) f:04 v:"/LIQ/Reportes" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Liquidaciones" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/LIQ/Reportes" | t: VARCHAR(50) f:04 v:"lqprrp004" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Repuestos" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/LIQ/Reportes" | t: VARCHAR(50) f:04 v:"lqprrp007" | Execution time : 0 00:00:00.00008 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"VENTAS" | t: VARCHAR(255) f:04 v:"" | t: VARCHAR(255) f:04 v:"/VENTAS" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00031 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"VENTAS" | t: VARCHAR(255) f:04 v:"/VENTAS/Mantenimientos" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Administracion NCF" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/VENTAS/Mantenimientos" | t: VARCHAR(50) f:04 v:"veprmt020" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Ciudades" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/VENTAS/Mantenimientos" | t: VARCHAR(50) f:04 v:"veprmt009" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Clientes" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/VENTAS/Mantenimientos" | t: VARCHAR(50) f:04 v:"veprmt101" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Codiciones de Pagos" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/VENTAS/Mantenimientos" | t: VARCHAR(50) f:04 v:"veprmt002" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Cotizacion" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/VENTAS/Mantenimientos" | t: VARCHAR(50) f:04 v:"veprmt049" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Facturas" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/VENTAS/Mantenimientos" | t: VARCHAR(50) f:04 v:"veprmt022" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Itbis y Prima" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/VENTAS/Mantenimientos" | t: VARCHAR(50) f:04 v:"veprmt012" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Notas de Creditos" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/VENTAS/Mantenimientos" | t: VARCHAR(50) f:04 v:"veprmt031" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Provincias" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/VENTAS/Mantenimientos" | t: VARCHAR(50) f:04 v:"veprmt013" | Execution time : 0 00:00:00.00029 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Rececepcion del Vehiculo" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/VENTAS/Mantenimientos" | t: VARCHAR(50) f:04 v:"veprmt080" | Execution time : 0 00:00:00.00008 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Tipos Negocios" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/VENTAS/Mantenimientos" | t: VARCHAR(50) f:04 v:"ccprmt015" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Zonas" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/VENTAS/Mantenimientos" | t: VARCHAR(50) f:04 v:"veprmt004" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Zonas-Provincias" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/VENTAS/Mantenimientos" | t: VARCHAR(50) f:04 v:"veprmt005" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Consultas" | t: VARCHAR(255) f:04 v:"VENTAS" | t: VARCHAR(255) f:04 v:"/VENTAS/Consultas" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Facturas" | t: VARCHAR(255) f:04 v:"Consultas" | t: VARCHAR(255) f:04 v:"/VENTAS/Consultas" | t: VARCHAR(50) f:04 v:"veprcs001" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"VENTAS" | t: VARCHAR(255) f:04 v:"/VENTAS/Reportes" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Clientes por Vendedores" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/VENTAS/Reportes" | t: VARCHAR(50) f:04 v:"veprrp011" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Informe Cotizaciones" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/VENTAS/Reportes" | t: VARCHAR(50) f:04 v:"veprrp048" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Informe Cotizaciones Por Productos" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/VENTAS/Reportes" | t: VARCHAR(50) f:04 v:"veprrp053" | Execution time : 0 00:00:00.00029 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Informe Ventas" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/VENTAS/Reportes" | t: VARCHAR(50) f:04 v:"veprrp015" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Informe Ventas Vendedores" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/VENTAS/Reportes" | t: VARCHAR(50) f:04 v:"veprrp050" | Execution time : 0 00:00:00.00008 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Tabla amortizacion" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/VENTAS/Reportes" | t: VARCHAR(50) f:04 v:"veprrp052" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Validacion facturas" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/VENTAS/Reportes" | t: VARCHAR(50) f:04 v:"veprrp001" | Execution time : 0 00:00:00.00008 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"CUENTAS POR COBRAR" | t: VARCHAR(255) f:04 v:"" | t: VARCHAR(255) f:04 v:"/CXC" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"CUENTAS POR COBRAR" | t: VARCHAR(255) f:04 v:"/CXC/Mantenimientos" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Anular Documentos" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/CXC/Mantenimientos" | t: VARCHAR(50) f:04 v:"ccprmt016" | Execution time : 0 00:00:00.00008 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Mantenimiento CXC" | t: VARCHAR(255) f:04 v:"Mantenimientos" | t: VARCHAR(255) f:04 v:"/CXC/Mantenimientos" | t: VARCHAR(50) f:04 v:"ccprmt001" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Consultas" | t: VARCHAR(255) f:04 v:"CUENTAS POR COBRAR" | t: VARCHAR(255) f:04 v:"/CXC/Consultas" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Estado de Cuenta x Cliente" | t: VARCHAR(255) f:04 v:"Consultas" | t: VARCHAR(255) f:04 v:"/CXC/Consultas" | t: VARCHAR(50) f:04 v:"ccprcs001" | Execution time : 0 00:00:00.00029 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"CUENTAS POR COBRAR" | t: VARCHAR(255) f:04 v:"/CXC/Reportes" | t: VARCHAR(50) f:04 v:"" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Analisis Saldo Pendiente" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CXC/Reportes" | t: VARCHAR(50) f:04 v:"ccprrp009" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Analisis Saldo por Vendedor" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CXC/Reportes" | t: VARCHAR(50) f:04 v:"ccprrp027" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Documentos" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CXC/Reportes" | t: VARCHAR(50) f:04 v:"ccprrp005" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Documentos X Vendedor" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CXC/Reportes" | t: VARCHAR(50) f:04 v:"ccprrp034" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Estados de Cuenta" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CXC/Reportes" | t: VARCHAR(50) f:04 v:"ccprrp014" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Estados de Cuenta CONDUCES" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CXC/Reportes" | t: VARCHAR(50) f:04 v:"ccprrp039" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Estados de Cuenta CONDUCES" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CXC/Reportes" | t: VARCHAR(50) f:04 v:"ccprrp051" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Informe Ingresos Por Equipos de Ventas" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CXC/Reportes" | t: VARCHAR(50) f:04 v:"ccprrp049" | Execution time : 0 00:00:00.00009 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Mayor Auxiliar" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CXC/Reportes" | t: VARCHAR(50) f:04 v:"ccprrp006" | Execution time : 0 00:00:00.00031 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Partida Pend. Cobro/Vendedor" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CXC/Reportes" | t: VARCHAR(50) f:04 v:"ccprrp016" | Execution time : 0 00:00:00.00006 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Registro Ventas (ITEBIS)" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CXC/Reportes" | t: VARCHAR(50) f:04 v:"ccprrp007" | Execution time : 0 00:00:00.00007 SQL: FETCH NEXT | 4gl source : demo.4gl line=154 | sqlcode : 100 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | into(tmp): 4 | t: VARCHAR(255) f:04 v:"Registro Ventas (ITEBIS)" | t: VARCHAR(255) f:04 v:"Reportes" | t: VARCHAR(255) f:04 v:"/CXC/Reportes" | t: VARCHAR(50) f:04 v:"ccprrp007" | Execution time : 0 00:00:00.00007 SQL: CLOSE | 4gl source : demo.4gl line=157 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | sql cursor : ident='cu0' (fglname='topic',module='demo') | fgl stmt : SELECT a.name AS nombre, a.parent, a.dirname, ' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = 'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = 'online' WHERE a.estado = 'online' ORDER BY orden,parent,nombre | sql stmt : SELECT a.name AS nombre, a.parent, a.dirname, N' ' AS programa, a.orden AS orden, a.dirname AS directorio FROM topics a WHERE a.estado = N'online' UNION SELECT DISTINCT b.name AS nombre, a.name AS parent, b.dirname AS directorio, b.program AS programa, b.orden AS orden, a.dirname FROM topics a INNER JOIN demos b ON a.dirname = b.dirname AND b.estado = N'online' WHERE a.estado = N'online' ORDER BY orden,parent,nombre | Execution time : 0 00:00:00.00003 SQL: SELECT MAX(a.description) FROM demos a WHERE a.program = ? | 4gl source : demo.4gl line=282 | ../ODI_common.h:00795(3) : adaptStatement: stmt type = 1 | ../ODI_common.h:00800(3) : adaptStatement: ifxemul = 1 | ../ODI_common_msv.h:01388(3) : Nat stmt1 = select MAX(a.description) from demos a where a.program = ? | ../ODI_common_msv.h:01254(3) : Fetch array size = 10 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | using: 1 | t: VARCHAR(50) f:01 v:"" | into: 1 | t: VARCHAR(255) f:04 v:"" | Execution time : 0 00:00:00.00090 url da /home/fourjs/gas/appdata/app/sistemas/decomarmol/dash\greeting.html SQL: SELECT MAX(a.description) FROM demos a WHERE a.program = ? | 4gl source : demo.4gl line=282 | ../ODI_common.h:00795(3) : adaptStatement: stmt type = 1 | ../ODI_common.h:00800(3) : adaptStatement: ifxemul = 1 | ../ODI_common_msv.h:01388(3) : Nat stmt1 = select MAX(a.description) from demos a where a.program = ? | ../ODI_common_msv.h:01254(3) : Fetch array size = 10 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | using: 1 | t: VARCHAR(50) f:01 v:"veprmt101" | into: 1 | t: VARCHAR(255) f:04 v:"Administracion de clientes Adicionar Modificar" | Execution time : 0 00:00:00.00155 url da /home/fourjs/gas/appdata/app/sistemas/decomarmol/dash\greeting.html programa veprmt101 SQL: SELECT MAX(a.ruta), MAX(a.tipo) FROM demos a WHERE a.program = ? | 4gl source : demo.4gl line=214 | ../ODI_common.h:00795(3) : adaptStatement: stmt type = 1 | ../ODI_common.h:00800(3) : adaptStatement: ifxemul = 1 | ../ODI_common_msv.h:01388(3) : Nat stmt1 = select MAX(a.ruta), MAX(a.tipo) from demos a where a.program = ? | ../ODI_common_msv.h:01254(3) : Fetch array size = 10 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | using: 1 | t: VARCHAR(255) f:01 v:"veprmt101" | into: 2 | t: VARCHAR(255) f:04 v:"C:\\\\Users\\\\public\\\\Documents\\\\sistema\\\\decomarmol\\..." | t: VARCHAR(255) f:04 v:"V" | Execution time : 0 00:00:00.01084 /bin/bash: line 0: cd: C:\Users\public\Documents\sistema\decomarmol\bin320: No such file or directory SQL: SELECT MAX(a.description) FROM demos a WHERE a.program = ? | 4gl source : demo.4gl line=282 | ../ODI_common.h:00795(3) : adaptStatement: stmt type = 1 | ../ODI_common.h:00800(3) : adaptStatement: ifxemul = 1 | ../ODI_common_msv.h:01388(3) : Nat stmt1 = select MAX(a.description) from demos a where a.program = ? | ../ODI_common_msv.h:01254(3) : Fetch array size = 10 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | using: 1 | t: VARCHAR(50) f:01 v:"" | into: 1 | t: VARCHAR(255) f:04 v:"" | Execution time : 0 00:00:00.00097 url da /home/fourjs/gas/appdata/app/sistemas/decomarmol/dash\greeting.html SQL: SELECT MAX(a.description) FROM demos a WHERE a.program = ? | 4gl source : demo.4gl line=282 | ../ODI_common.h:00795(3) : adaptStatement: stmt type = 1 | ../ODI_common.h:00800(3) : adaptStatement: ifxemul = 1 | ../ODI_common_msv.h:01388(3) : Nat stmt1 = select MAX(a.description) from demos a where a.program = ? | ../ODI_common_msv.h:01254(3) : Fetch array size = 10 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | using: 1 | t: VARCHAR(50) f:01 v:"ipprmt002" | into: 1 | t: VARCHAR(255) f:04 v:"Adicionar Modificar Codigos Productos Terminados" | Execution time : 0 00:00:00.00163 url da /home/fourjs/gas/appdata/app/sistemas/decomarmol/dash\greeting.html programa ipprmt002 SQL: SELECT MAX(a.ruta), MAX(a.tipo) FROM demos a WHERE a.program = ? | 4gl source : demo.4gl line=214 | ../ODI_common.h:00795(3) : adaptStatement: stmt type = 1 | ../ODI_common.h:00800(3) : adaptStatement: ifxemul = 1 | ../ODI_common_msv.h:01388(3) : Nat stmt1 = select MAX(a.ruta), MAX(a.tipo) from demos a where a.program = ? | ../ODI_common_msv.h:01254(3) : Fetch array size = 10 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | using: 1 | t: VARCHAR(255) f:01 v:"ipprmt002" | into: 2 | t: VARCHAR(255) f:04 v:"C:\\\\Users\\\\public\\\\Documents\\\\sistema\\\\decomarmol\\..." | t: VARCHAR(255) f:04 v:"V" | Execution time : 0 00:00:00.00153 /bin/bash: line 0: cd: C:\Users\public\Documents\sistema\decomarmol\bin320: No such file or directory programa ipprmt002 SQL: SELECT MAX(a.ruta), MAX(a.tipo) FROM demos a WHERE a.program = ? | 4gl source : demo.4gl line=214 | ../ODI_common.h:00795(3) : adaptStatement: stmt type = 1 | ../ODI_common.h:00800(3) : adaptStatement: ifxemul = 1 | ../ODI_common_msv.h:01388(3) : Nat stmt1 = select MAX(a.ruta), MAX(a.tipo) from demos a where a.program = ? | ../ODI_common_msv.h:01254(3) : Fetch array size = 10 | sqlcode : 0 | curr driver : ident='dbmsnc_17' | curr connection : ident='decomarmol' (dbspec=[decomarmol]) | using: 1 | t: VARCHAR(255) f:01 v:"ipprmt002" | into: 2 | t: VARCHAR(255) f:04 v:"C:\\\\Users\\\\public\\\\Documents\\\\sistema\\\\decomarmol\\..." | t: VARCHAR(255) f:04 v:"V" | Execution time : 0 00:00:00.00118 /bin/bash: line 0: cd: C:\Users\public\Documents\sistema\decomarmol\bin320: No such file or directory