2256 lines
217 KiB
Plaintext
2256 lines
217 KiB
Plaintext
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
|