I'm trying to add a long sql statement in a string variable, but it's truncated to 264 characters. Since the sql is not complete then the program crashes.
I've made a testprogram for concattenating long strings, and there it works perfectly. Is this a setting of some kind?
The source is as follows, where lclSelectedList is a global variable holding a list of fieldnames, seperated by a "," and the msgbox results in 264:

Dim lclSql As String
Dim lclQuery As String

On Error GoTo process_error
lclConnected = False

lclSql = ""
lclQuery = ""
lclSql = "select " & lclSelectList & " from " & lclTable & " LEFT JOIN tblDocExtraInfo ON tblDocument.docid = tblDocExtraInfo.docid "

If Len(lclCriteria) > 0 Then
lclSql = lclSql & " where "
lclSql = lclSql & lclCriteria
Else
lclSql = lclSql & " where tbldocument.Docid = " & CStr(lclId)
MsgBox Len(lclSql)
End If