Skip to main content
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Text Limitation

Hi,

I am new to Qlikview.  However I have loaded data from a database using an ODBC connection.  I then created a text box and set a code up so all information from a text field within the database went into the textbox (the text was taken from a field called prob_text) .  However I noticed that it only shows as a certain amount of characters.

Thefore just before my SQL Statement, I added in the following:

LOAD * text (prob_text). 

This seemed to add a bit more data into the text box, but not enough.  I was wondering if there is a way I can set my above Statement before my SQL to add more than 255 characters to a text field.

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

This is usually a driver setting. What database and driver are you uisng?

-Rob

Not applicable
Author

Hi,

I am not sure what database I am using, however the driver for the ODBC connection is: MYSQL ODBC 3.51 Driver.