FoxPro/Visual FoxPro - Conflicto de Actualizacion

 
Vista:
sin imagen de perfil

Conflicto de Actualizacion

Publicado por Zack (23 intervenciones) el 07/06/2007 20:27:53
Tengo un MySQL como motor de base de datos, y estoy tratando de usarlo con vistas remotas, todo me salio perfecto, hasta que tuve que sobreescribir un registro.
Y me respondio con el mensaje "CONFLICTO DE ACTUALIACION" sin dejarme acceder a la vista, con un tablerevert() puedo acceder de nuevo a el.
No es un campo clave, si alguien me puede ayudar....please
Gracias

Ej.
**** VISTA REMOTA

SELECT *;
FROM ;
kdet_cta Kdet_cta

DBSetProp(ThisView,"View","SendUpdates",.T.)
DBSetProp(ThisView,"View","BatchUpdateCount",15)
DBSetProp(ThisView,"View","CompareMemo",.T.)
DBSetProp(ThisView,"View","FetchAsNeeded",.T.)
DBSetProp(ThisView,"View","FetchMemo",.T.)
DBSetProp(ThisView,"View","FetchSize",100)
DBSetProp(ThisView,"View","MaxRecords",-1)
DBSetProp(ThisView,"View","Prepared",.F.)
DBSetProp(ThisView,"View","ShareConnection",.T.)
DBSetProp(ThisView,"View","AllowSimultaneousFetch",.T.)
DBSetProp(ThisView,"View","UpdateType",1)
DBSetProp(ThisView,"View","UseMemoSize",255)
DBSetProp(ThisView,"View","Tables","kdet_cta")
DBSetProp(ThisView,"View","WhereType",3)

DBSetProp(ThisView+".a_cliente","Field","DataType","N(3)")
DBSetProp(ThisView+".a_cliente","Field","UpdateName","kdet_cta.a_cliente")
DBSetProp(ThisView+".a_cliente","Field","KeyField",.F.)
DBSetProp(ThisView+".a_cliente","Field","Updatable",.T.)

DBSetProp(ThisView+".a_tip_docu","Field","DataType","N(3)")
DBSetProp(ThisView+".a_tip_docu","Field","UpdateName","kdet_cta.a_tip_docu")
DBSetProp(ThisView+".a_tip_docu","Field","KeyField",.T.)
DBSetProp(ThisView+".a_tip_docu","Field","Updatable",.T.)

DBSetProp(ThisView+".a_nro_docu","Field","DataType","N(13)")
DBSetProp(ThisView+".a_nro_docu","Field","UpdateName","kdet_cta.a_nro_docu")
DBSetProp(ThisView+".a_nro_docu","Field","KeyField",.T.)
DBSetProp(ThisView+".a_nro_docu","Field","Updatable",.T.)

DBSetProp(ThisView+".a_for_pago","Field","DataType","N(3)")
DBSetProp(ThisView+".a_for_pago","Field","UpdateName","kdet_cta.a_for_pago")
DBSetProp(ThisView+".a_for_pago","Field","KeyField",.F.)
DBSetProp(ThisView+".a_for_pago","Field","Updatable",.T.)

DBSetProp(ThisView+".a_cuota","Field","DataType","N(3)")
DBSetProp(ThisView+".a_cuota","Field","UpdateName","kdet_cta.a_cuota")
DBSetProp(ThisView+".a_cuota","Field","KeyField",.F.)
DBSetProp(ThisView+".a_cuota","Field","Updatable",.T.)

DBSetProp(ThisView+".a_moneda","Field","DataType","N(3)")
DBSetProp(ThisView+".a_moneda","Field","UpdateName","kdet_cta.a_moneda")
DBSetProp(ThisView+".a_moneda","Field","KeyField",.F.)
DBSetProp(ThisView+".a_moneda","Field","Updatable",.T.)

DBSetProp(ThisView+".a_importe","Field","DataType","N(15,2)")
DBSetProp(ThisView+".a_importe","Field","UpdateName","kdet_cta.a_importe")
DBSetProp(ThisView+".a_importe","Field","KeyField",.F.)
DBSetProp(ThisView+".a_importe","Field","Updatable",.T.)

DBSetProp(ThisView+".a_saldo","Field","DataType","N(15,2)")
DBSetProp(ThisView+".a_saldo","Field","UpdateName","kdet_cta.a_saldo")
DBSetProp(ThisView+".a_saldo","Field","KeyField",.F.)
DBSetProp(ThisView+".a_saldo","Field","Updatable",.T.)

DBSetProp(ThisView+".a_fec_vto","Field","DataType","D")
DBSetProp(ThisView+".a_fec_vto","Field","UpdateName","kdet_cta.a_fec_vto")
DBSetProp(ThisView+".a_fec_vto","Field","KeyField",.F.)
DBSetProp(ThisView+".a_fec_vto","Field","Updatable",.T.)

DBSetProp(ThisView+".a_fecha","Field","DataType","D")
DBSetProp(ThisView+".a_fecha","Field","UpdateName","kdet_cta.a_fecha")
DBSetProp(ThisView+".a_fecha","Field","KeyField",.F.)
DBSetProp(ThisView+".a_fecha","Field","Updatable",.T.)

*** MODIFICACION DE CAMPO

replace a_importe WITH gialiqui.monto_fac
replace a_saldo WITH gialiqui.monto_fac
Valora esta pregunta
Me gusta: Está pregunta es útil y esta claraNo me gusta: Está pregunta no esta clara o no es útil
0
Responder