I’m testing out the new real-time field connectivity to external ODBC SQL source. In my case I’m using MySQL and connecting with MyODBC. Everything seem to be working, I can add/delete/modify Notes records and it reflects fine in the SQL db. If I edit SQL db data it shows up in Notes just fine. The only problem is that I only see the key column and not the other fields in the view. If I open the document then all see all the data.
For example, I have a simple employee reocrd that have EMPNO, FIRSTNAME, LASTNAME, PHONENO where EMPNO is the key. In the Notes view I have these four columns listed. No fancy computed column, just the field itself. In the view I can only see the key EMPNO, but not the other columns. I made sure that I have the field data store locally as well. If I right-click on the doc in the view level, I see all the data for each of the fields and the SUMMARY flag is on just like the EMPNO (so it should show up in views fine). But, I simply don’t see them until I open the document.
Is there something I’m dong wrong? Or, could this be a bug? I’m using 6.0.1 (haven’t apply the CF1 yet).