>Hi All,
>
>I have a memo field(m_Msg) in one of my table and when I tried to use the INSERT command by doing the following.
>
>cSql1 = "INSERT INTO Log_This(m_Msg) VALUES (c_InsMsg)"
>&cSql1
>
>VFP gave me "Command contains unrecognized phrase/keywords" because c_InsMsg contains more than 255 characters for cSql1 to cope with. Is there another way of doing this without breaking the code? Any Suggestion? TIA
If you're using the code you show, the 255 chars in c_InsMsg shouldn't be a problem. However, you could have that problem if you're really using something like this:
cSQL1 = "INSERT INTO Log_This (m_Msg) VALUES (" + c_InsMsg +")"
&cSQL1