0 Replies Latest reply on Apr 12, 2013 10:45 PM by curlyharry

    Text Field issues with ODBC to MSSQL

    curlyharry

      Title

      Text Field issues with ODBC to MSSQL

      Post

           I am using FileMaker V11 advanced. I am displaying and editting via ODBC connection to MSSQL database. I have an issue when displaying and modifying Text fields. I get an extra CR/LF between lines in the Field when I display the text field from the MSSQL table. If I modify the text and store it back to MSSQL it removes all of the CRLF from text when viewed from the VB6 program that normally displays and edits this field in my other program.

           Has anyone seen this type of messing up the text field data before. I have searched all over the internet for anyone seeing this to no avail. I do not think I am doing anything out of the ordinary that hundreds of others would have seen before but nobody is complaining so it must be me.

           Filemaker -> Text field displaying MSSQL Varchar field

           Thanks in advance.