hi!
lcMemoContent='something'+chr(13)+'something'
SQLEXEC(nConnectHandle, "INSERT INTO MyTable (MyMemoField) values (?lcMemoContent)")
As you see, using ? you can provide any data to the SQLEXEC() command. ODBC parse '?' parameters by another way. VFP provides information for ? parameters from the variables and data fields specified just after the '?'.
HTH.
>my question was regarding odbc
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.