>scatter memvar >test = SQLEXEC(m.lnHandle, "INSERT INTO correios (nome, rua); > VALUES (m.nome,m.rua)") > >= MESSAGEBOX(test) > > >It returns -1 > > >Using ' ' it seems to work: > ><pre> >scatter memvar >test = SQLEXEC(m.lnHandle, "INSERT INTO correios (nome, rua); > VALUES ('m.nome', 'm.rua')") > >= MESSAGEBOX(test) > > >It returns + 1 > > >However it replaces literal value 'm.nome' and 'm.rua' instead of value stored in variable > > >>
scatter memvar test = SQLEXEC(m.lnHandle, "INSERT INTO correios (nome, rua) VALUES (?m.nome,?m.rua)")This will correctly insert your information using variables as parameters.