Published on InterSystems Developer Community (https://community.intersystems.com)

Home > Insert memo field via ODBC in PHP

Question
Rosalie Banlaygas · Sep 26, 2021

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

#Caché #TrakCare
Product version: Caché 2012.1

Source URL:https://community.intersystems.com/post/insert-memo-field-odbc-php