The following statement is issued to insert a record on mysql database. If issue it on command window of VFP the record is inserted, but if issue it inside method of form the record is not inserted and retval returns -1.
retval = SQLEXEC(lnHandle,'INSERT INTO fcdl.fatura (codigo, referencia) VALUES (' + m.codigo + "," + m.dtinvertida + ')')
What is wrong?
Antonio Carlos Kleinübing
Systems Analyst
