if I used foxpro database there’re no limit column when I save
the records more than 50 column but if I used mysql server to
save from foxpro there are limit column and then show warning
“command contain unrecognized phrase/keyword” like code below
:
SQLEXEC(test,”LOCK TABLE LocalOnLine.vouchers WRITE”)
SQLPREPARE(test,”UPDATE LocalOnLine.vouchers SET
division=?v_dv,agent=?v_ag,guide=?v_gd,invoice=?v_iv,month=?v_mt,years=?v_yr,voucher=?v_vc,;
bill=?v_vl,cgroup=?v_gr,client=?v_cl,client1=?v_c1,client2=?v_c2,remarks=?v_rk
WHERE month=?v_mt and years=?v_yr and voucher=?v_vc and
totalrp+totalus>0″)
server=SQLEXEC(test)
SQLEXEC(test,”UNLOCK TABLE”)
IF server<0
MESSAGEBOX('Update voucher '+v_vc+' '+v_vd+' '+ALLTRIM(v_nm)+'
failed',16,'Warning')
ENDIF
what wrong with my code above and there are limit column to save
from foxpro to mysql server ?
please help me, …
[Read more]