Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error: String is too long to fit
Message
From
10/11/2004 16:13:19
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Error: String is too long to fit
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows '98
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00960214
Message ID:
00960214
Views:
48
Hello, i'm having an error in a sql statement, String is too long to fit:
SELECT Cl_servicios.id_llam_serv,Cl_servicios.id_report, Cl_servicios.id_task,;
  Cl_servicios.fech_inic, Cl_servicios.fcompromiso, Cl_cliente.nombre_cli, Cl_ingeniero.nombre_ing, Cl_servicios.observ,;
  Cl_clasificacionservicio.tipserv,;
  Cl_calificacionservicio.nombrecalificacion,Cl_servicios.freciborep,(iif(Cl_servicios.ming=.t.,"SI","NO")) as cambioing,(iif(Cl_servicios.mfcomp=.t.,"SI","NO")) as cambiocomp,Cl_servicios.fech_fin,Cl_servicios.tespera_sistema,;
Cl_servicios.tespera_respuesta, Cl_servicios.tpo_transpor, cmonth(Cl_servicios.fech_fin) as mes,;
(iif(Cl_servicios.sxv=.t.,"7x24","5x8 ")) as jornada, Cl_equipos.nombreproducto as equipo, (iif(Cl_servicios.chk_list=.t.,"SI","NO")) as chklist,;
(iif(Cl_servicios.mc=.t.,"SI","NO")) as MC, (iif(Cl_servicios.mp=.t.,"SI","NO")) as MP, (iif(Cl_servicios.instalacion=.t.,"SI","NO")) as inst,;
(iif(Cl_servicios.servicio=.t.,"SI","NO")) as serv,cdow(Cl_servicios.fech_inic) as dia, Cl_servicios.fech_inic as finicio,;
alltrim(str(hour(Cl_servicios.fech_inic)))+":"+alltrim(str(minute(Cl_servicios.fech_inic))) as Hini, alltrim(str(hour(Cl_servicios.fech_fin)))+":"+alltrim(str(minute(Cl_servicios.fech_fin))) as Hfin ,;
left(Cl_servicios.desc_llamada,300) as solucion, left(Cl_servicios.detalle,300) as detalle;
 FROM  helpdesk!cl_servicios ;
    LEFT OUTER JOIN helpdesk!cl_ingeniero ON Cl_servicios.id_ing = Cl_ingeniero.id_ing;
    LEFT OUTER JOIN helpdesk!cl_cliente ON Cl_servicios.id_cli = Cl_cliente.id_cli ;
    LEFT OUTER JOIN helpdesk!cl_calificacionservicio ON Cl_servicios.idcalificacion = Cl_calificacionservicio.idcalificacion ;
    LEFT OUTER JOIN helpdesk!cl_clasificacionservicio ON Cl_servicios.id_tipserv = Cl_clasificacionservicio.id_tipserv ;
    LEFT OUTER JOIN helpdesk!cl_equipos ON Cl_servicios.id_equipo = Cl_equipos.id_equipo;
  WHERE Sys(11,cl_servicios.fech_inic) >= sys(11,m.ini) and;
             Sys(11,cl_servicios.fech_inic) <= Sys(11,m.fin) ;
  INTO cursor tablest;
order by id_llam_serv
And this same code it was working fine, but now i don't know what's wrong?
Thanks to help me to fit this problem.
Next
Reply
Map
View

Click here to load this message in the networking platform