 category proc descripciu8c3b3n descripciu8c3b3n descripciu8c3b3n traslada lasu800 modificaciones hechas sobre lau800 tabla vidquoten3tmp au800 lau800 definitiva tabla vidquoten3 composiciu8c3b3n composiciu8c3b3n composiciu8c3b3n tabla vidquoten3 tabla vidquoten3tmp cu8c3b3digo cu8c3b3digo cu8c3b3digo -- -------------------------------------------------------------------------------- -- routine ddlu800 -- note comments before andu800 after theu800 routine body will notu800 beu800 stored byu800 theu800 server -- -------------------------------------------------------------------------------- delimiter create definer sas_admin procedure grabaitempresupuestotmp inu800 pvidquoteid intu800 5u800 inu800 pvidquoteitem intu800 5u800 begin delete from vidquoten3 where vidquoteid pvidquoteid andu800 vidquoteitem pvidquoteitem; -- ------------------------------------------------------------- insert into vidquoten3 vidquoteid vidquoteitem vidquoteprodid vidquoteprodcantidad vidquoteelementoid vidquotecomposicid vidquoteelementopm vidquoteprecio vidquotepreciop vidquoteincluyedet select vidquoteid vidquoteitem vidquoteprodid vidquoteprodcantidad vidquoteelementoid vidquotecomposicid vidquoteelementopm vidquoteprecio vidquotepreciop ifu800 vidquoteprodid vidquoteelementoid 0u800 vidquoteincluyedet asu800 vidquoteincluyedet from vidquoten3tmp asu800 t1u800 where t1u800u82evidquoteid pvidquoteid andu800 t1u800u82evidquoteitem pvidquoteitem andu800 t1u800u82evidquotequickselect 1u800; -- ------------------------------------------------------------- delete from vidquoten3tmp where vidquoteid pvidquoteid andu800 vidquoteitem pvidquoteitem; endu800 bitu8c3a1cora bitu8c3a1cora bitu8c3a1cora 20121002 gestiu8c3b3n interna deu800 correcciu8c3b3n automu8c3a1tico ante losu800 ctrl vidquoteincluyedet . modifica elu800 valor proveniente delu800 formulario para elu800 atributo cuando elu800 cu8c3b3digo deu800 producto yu800 cu8c3b3digo deu800 elemento sonu800 iguales porque nou800 corresponde agregarlo yau800 queu800 yau800 estu8c3a1 incluido elu800 text dentro deu800 lau800 descripciu8c3b3n delu800 producto. anterior delimiter create definer sas_admin procedure grabaitempresupuestotmp inu800 pvidquoteid intu800 5u800 inu800 pvidquoteitem intu800 5u800 begin delete from vidquoten3 where vidquoteid pvidquoteid andu800 vidquoteitem pvidquoteitem; insert into vidquoten3 vidquoteid vidquoteitem vidquoteprodid vidquoteprodcantidad vidquoteelementoid vidquoteprecio vidquotepreciop vidquoteincluyedet select vidquoteid vidquoteitem vidquoteprodid vidquoteprodcantidad vidquoteelementoid vidquoteprecio vidquotepreciop vidquoteincluyedet from vidquoten3tmp where vidquoteid pvidquoteid andu800 vidquoteitem pvidquoteitem; endu800 usou800 usou800 usou800 form presupuesto macro botoneditarcomponentes 