error Microsoft][ODBC Visual FoxPro Driver]
Publicado por Oscar (4 intervenciones) el 05/10/2007 18:28:24
Holas me podrian ayudar...
Hice una aplicacion en PowerBuilder que se conecte a tablas DBF de fox.. en la tabla hay un campo memo... cuando hago un update al Datawindows...
SQLSTATE = 37000
[Microsoft][ODBC Visual FoxPro Driver]El comando contiene una frase o palabra clave no reconocida.
No changes made to database.
UPDATE sisaba\bases\ordcomd.dbf SET cla_gas = '5.3.11.30.008', val_sol = 1173.1000000000000000, det_pro = 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA' WHERE cod_emp = '01' AND tip_doc = 'ORCOM' AND nro_ord = 171 AND cod_pro = '76.750.050' AND can_ord = 1 AND can_bon = 0 AND can_ing = 1 AND cod_met = '0001' AND fte_fto = '09' AND cla_gas = '5.3.11.30.008' AND cta_ctb = '2617 ' AND val_sol = 1173.1 AND val_dol = 0 AND mon_sol = 1173.1 AND det_pro = 'CILINDRO/DRUM. DE CODIGO 113R670' AND est_reg = 1 AND cod_dep = 1 AND cod_reg = 0 AND cod_ofi = '01 ' AND cod_sia = ' ' AND mon_dol = 0 AND mar_mod = ' '
*********************************************
El campo (det_pro) es un memo, powerbuilder me permite grabar solo 255 Caracteres...
cuando pasa esa longitud... ahi sale el error..
me conecto a travez de ODBC... Microsoft Visual FoxPro Driver
Gracias y espero su respuesta.
Hice una aplicacion en PowerBuilder que se conecte a tablas DBF de fox.. en la tabla hay un campo memo... cuando hago un update al Datawindows...
SQLSTATE = 37000
[Microsoft][ODBC Visual FoxPro Driver]El comando contiene una frase o palabra clave no reconocida.
No changes made to database.
UPDATE sisaba\bases\ordcomd.dbf SET cla_gas = '5.3.11.30.008', val_sol = 1173.1000000000000000, det_pro = 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA' WHERE cod_emp = '01' AND tip_doc = 'ORCOM' AND nro_ord = 171 AND cod_pro = '76.750.050' AND can_ord = 1 AND can_bon = 0 AND can_ing = 1 AND cod_met = '0001' AND fte_fto = '09' AND cla_gas = '5.3.11.30.008' AND cta_ctb = '2617 ' AND val_sol = 1173.1 AND val_dol = 0 AND mon_sol = 1173.1 AND det_pro = 'CILINDRO/DRUM. DE CODIGO 113R670' AND est_reg = 1 AND cod_dep = 1 AND cod_reg = 0 AND cod_ofi = '01 ' AND cod_sia = ' ' AND mon_dol = 0 AND mar_mod = ' '
*********************************************
El campo (det_pro) es un memo, powerbuilder me permite grabar solo 255 Caracteres...
cuando pasa esa longitud... ahi sale el error..
me conecto a travez de ODBC... Microsoft Visual FoxPro Driver
Gracias y espero su respuesta.
Valora esta pregunta


0