QA limitation or simply I am doing anything wrong?

QA limitation or simply I am doing anything wrong?

Post by RW5yaW » Wed, 24 Aug 2005 15:27:05


Dear all,

I am trying do a autocontained select but on the results panel appears the
line cut off:

select 'insert into
cargaprocesos(idproceso,proceso,ruta,respfich,rutabak,estado,fechaultimacarga,nota,dts,repositorio,servdts,idaplicacion,duracionult,duracionrel,marcafnul,marcabak,horas,frecuencia,responsable,dias,casoerror,servdesa,docu,marcaffecha,ficherofecha,ficheronul,enespera,ana)
values(' + convert(char(2),idproceso) + ')'
from cargaprocesos where proceso in('ABS_RecuperarCajero')


As ouput:


----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
insert into
cargaprocesos(idproceso,proceso,ruta,respfich,rutabak,estado,fechaultimacarga,nota,dts,repositorio,servdts,idaplicacion,duracionult,duracionrel,marcafnul,marcabak,horas,frecuencia responsable,dias,casoerror,servdesa,docu,marcaffe

(1 filas afectadas)

stopped in "marcaffe" field.

Does anyone has suffered any experience with that? Is customizable?

Regards,
 
 
 

QA limitation or simply I am doing anything wrong?

Post by Roji. P. T » Wed, 24 Aug 2005 15:40:35

Change the below setting.

Tools --> Options --> Results --> Maximum Character Per column.

--
Roji. P. Thomas
Net Asset Management
http://www.yqcomputer.com/

 
 
 

QA limitation or simply I am doing anything wrong?

Post by Q2hhbmRyY » Wed, 24 Aug 2005 15:45:15

Hi

The problem is with the buffer size:

just goto Tools > Options

on the 'Results' tab, change the maximum characters per column from 256 to
some 8000.

the u can see the expected result:


aslo modift the query as:

select 'insert into
cargaprocesos(idproceso,proceso,ruta,respfich,rutabak,estado,fechaultimacarga,nota,dts,repositorio,servdts,idaplicacion,duracionult,duracionrel,marcafnul,marcabak,horas,frecuencia,responsable,dias,casoerror,servdesa,docu,marcaffecha,ficherofecha,ficheronul,enespera,ana)
values(' + convert(char(2),idproceso) + ')'
from cargaprocesos where proceso in('ABS_RecuperarCajero') as [Result]

to avoid the - across 3 lines

please let me know if u have any questions



--
best Regards,
Chandra
http://www.yqcomputer.com/
http://www.yqcomputer.com/
---------------------------------------
 
 
 

QA limitation or simply I am doing anything wrong?

Post by RW5yaW » Wed, 24 Aug 2005 15:48:06

Thanks a lot Roji
 
 
 

QA limitation or simply I am doing anything wrong?

Post by Q2hhbmRyY » Wed, 24 Aug 2005 15:57:07

oops,

select 'insert into
cargaprocesos(idproceso,proceso,ruta,respfich,rutabak,estado,fechaultimacarga,nota,dts,repositorio,servdts,idaplicacion,duracionult,duracionrel,marcafnul,marcabak,horas,frecuencia,responsable,dias,casoerror,servdesa,docu,marcaffecha,ficherofecha,ficheronul,enespera,ana)
values(' + convert(char(2),idproceso) + ')' as [Result]
from cargaprocesos where proceso in('ABS_RecuperarCajero')

I made a mistake in the query

--
best Regards,
Chandra
http://www.yqcomputer.com/
http://www.yqcomputer.com/
---------------------------------------
 
 
 

QA limitation or simply I am doing anything wrong?

Post by RW5yaW » Wed, 24 Aug 2005 15:59:34

hi Chandra, thanks for your input but it doesn't works:

using as [result]

Servidor: mensaje 156, nivel 15, estado 1, lnea 6
Incorrect syntax near the keyword 'as'.
 
 
 

QA limitation or simply I am doing anything wrong?

Post by RW5yaW » Wed, 24 Aug 2005 16:03:01

t's ok. Take care yourself,

"Chandra" wrote: