| Migracion VFP a SQL Server
Hola, tengo un problema al querer migrar de Visual Fox a SQL Server una tabla con Muchos Campos, al ejecutar el SQLEXEC de VFP me da error de "cadena demasiado larga", el codigo es el siguiente:
=comando( "insert into kilosdetalle (id,tipo,edaddesde,edadhasta,sexo,ganadesde,ganaha sta,semestre,distadesde,distahasta,kime01,kime02,k ime03,kime04,kime05,kime06,kime07,kime08,kime09,ki me10,kime11,kime12,descahembras,descaedad,recagana das) values (";
+allt(str(0))+","+allt(str(tipo))+","+allt(str(ed) )+","+allt(str(eh))+","+allt(str(sx))+","+allt(str (gd))+","+allt(str(gh))+","+allt(str(sm))+","+allt (str(dd))+","+allt(str(dh))+",";
+allt(str(km01))+","+allt(str(km02))+","+allt(str( km03))+","+allt(str(km04))+","+allt(str(km05))+"," +allt(str(km06))+",";
+allt(str(km07))+","+allt(str(km08))+","+allt(str( km09))+","+allt(str(km10))+","+allt(str(km11))+"," +allt(str(km12))+",";
+allt(str(deshem))+","+allt(str(desedad))+","+allt (str(recgan))+ ")" )
la funcion comando es:
************************************************** *******
FUNCTION Comando
************************************************** *******
lpara x1,x2
local Xres
if type("x2")<>"C"
Xres=sqlexec(SQLConexion,x1)
endif
if type("x2")="C"
Xres=sqlexec(SQLConexion,x1,x2)
endif
IF Xres<=0
WAIT WINDOW "Error en Sqlexec - "+allt(x1)
ENDIF
Return
************************************************** *******
LES AGRADECERIA A ALGUIEN QUE ME PUEDA AYUDAR |