Having trouble displaying an SQL 7 'text' field using an ADO .ttx file.
Posted on 2001-06-29
The SQL table I'm reporting from has a 'text' field which contains anywhere from 2KB to 150KB worth of text. The only rows in the table that will display are those which are 2KB in size. Thus, I'm guessing the root of this problem is because the field is defined as type 'memo' in the .ttx file.
I'm creating the .ttx file from within the VB code like this:
Is the 'memo' field the root of my problem? If so, is Crystal Reports capable of handling the 'text' field and how?
Here is the connection code if this helps:
.Provider = "MSDASQL"
.ConnectionString = ConnectString
.CursorLocation = adUseClient
'Create the recordset for the main report
.CursorType = adOpenDynamic
.Open "select LogText from TableX", ADOcn