Insert memo field via ODBC in PHP
Our company is using Cache FDBMS for Medtrak.
I am trying to insert a record with the following data types : date, time, string and memo field (multiline). The SQL insert/update works fine without the memo field.
Here's my SQL statement
Insert into MR_SUB (MRSub_Date,MRSUB_Time,MRSUB_Update,MRSUB_Desc) values(:DTE, :time, :use, :remarks)
Based on FDBMS docs. MRSUB_Desc is a multiline/memo data type
Hope somebody can help. Thanks