insert是插入数据记录,你写上pos=102是没有作用的
要用update
connmy.execute ("update t_iteminfo set charguid="&charguid&",p1=-999555071,p2=-934214910,p3=-1130822910 where pos=102")
connmy.execute "insert into t_iteminfo (charguid,p1,p2,p3,pos) VALUES (" & charguid & ",-999555071,-934214910,-1130822910,102)"