Memo Field - Data not loading

[#1]

Hi,

Does anyone know if there is a limit on the amount of text qlikview can import within a memo field on a table?

I am curently experiencing problems importing a table from foxpro that includes a memo field.  I have found that some fields appear blank whilst others contain the text (I have checked the actual tables and they all contain text).

I have tested over-writing the contents of memo fields with a short amount of text......this seems to work.  However I get blank lines again if I overwrite with a large amount of text.

Has oneone else had the same issues?

Does anyone know if there is a way to resolve it?

Many thanks

[#2]

Has anyone got any ideas on this one?

I tried updating to QV11 sr2 to see if it made a difference (it didnt).

I have been looking through the forums and cannot really find anything.

[m_woolf]

You might try loading the data into Excel to see if it is a problem with the odbc driver and not a qlikview issue.

[hic]

There should be no limits in QlikView, but the DB or ODBC/OLEDB might have some limitations. Try with an other ODBC client like mwoolf suggests. Also, you can try to use the len() function in the script to debug:

Load *,

   Len(TextField) as x;  // Length of string that QlikView receives from ODBC

SQL SELECT *,

  Len(TextField) as y  // Length of string that DB has

   ...

HIC