AnsweredAssumed Answered

SQL Records showing as Question Marks

Question asked by stewbrinegar on Mar 25, 2011
Latest reply on Nov 6, 2011 by benauerbach

Title

SQL Records showing as Question Marks

Post

Hi there,

I am trying to sync my FMP databast to SQL Server for the first time and a funny thing is happening. When I open the linked database in FM, it shows the correct number of records. In Table View, I can see the first few records , but everything below is filled with question marks. Then, after a few seconds, the number of records decreases to 6. As far as I can tell, no data is destroyed on the SQL side. I suspect something is corrupt in the data, which causes it not to display properly. I was wondering if there is a setting or something I should monitor to make my records are visible.

I am running FMP 11 Advanced for OS X

-S

Picture_11.png

Outcomes