This isn't a bug, but rather, a limitation (I think), and a request.

[GregThompson]

I'm pulling back large amounts of data using an ADODB connection with AutoIT and if I put the data into a 2D array it's truncating the results per element(cell). If I change it up and pull the data back with the SSMS and paste into an Excel file, then read cell by cell into strings I get all the data I'm looking for so I know it's some kind of size limit, or character limit with 2D array elements. Any thoughts on this, I'd LOVE to be able to just increase the element sizes up to like 100,000 characters?

Edited January 31, 2013 by GregThompson

[JLogan3o13]

Here's a thought, how about providing an example

[jdelaney]

What's the end result? If the data set is very large, it takes a lot of time to migrate it to an array...which is a waste of time, when you can instead loop through, and print to the end location, such as an excel document, txt file, etc...cut out the middle man

[kylomas]

Greg,

so I know it's some kind of size limit, or character limit with 2D array elements. Any thoughts on this

Yes, proof of concept. The console outputs the length of each cell in a 2D array.

;
;
;

local $str, $array[10][5]

for $1 = 0 to ubound($array,1) - 1
    for $2 = 0 to ubound($array,2) - 1
        for $3 = 1 to 50000
            $str &= string($3)
        Next
        $array[$1][$2] = $str
        $str = ''
    next
next

for $1 = 0 to ubound($array,1) - 1
    ConsoleWrite('Length : ')
    for $2 = 0 to ubound($array,2) - 1
        consolewrite('Element # [' & $1 & ',' & $2 & '] ' & stringlen($array[$1][$2]) & ' ')
    next
    ConsoleWrite(@LF)
next

Post your code as suggested by JLogan3o13...

kylomas

[Bowmore]

There is no limit on the number of characters that can be strored in an AutoIt array element, other than the basic Max string length, array size, max integer etc.

I believe what the OP is probably coming up against the 259 character limit for what can be displayed in a standard windows ListView item and sub-items. The full string is still correctly stored in the ListView just not viewable. To view it you need to display the Listview sub-item, with focus, text in an edit control. There is also a limit on the total number of characters that can be viewed in a all the subitems of a single list view item. I can't remember the exact value, around 4000 I think This can result in some fields appearing to be empty when using a ListView to display large database records that exceed this value.

[Edano]

There is no limit on the number of characters that can be strored in an AutoIt array element, other than the basic Max string length, array size, max integer etc.

I believe what the OP is probably coming up against the 259 character limit for what can be displayed in a standard windows ListView item and sub-items. The full string is still correctly stored in the ListView just not viewable. To view it you need to display the Listview sub-item, with focus, text in an edit control. There is also a limit on the total number of characters that can be viewed in a all the subitems of a single list view item. I can't remember the exact value, around 4000 I think This can result in some fields appearing to be empty when using a ListView to display large database records that exceed this value.

.

just want to agree, if others have the same problem. took me some time to find it out.

there is a limit on the displayed string length of listview (sub)items, but if you read it out with _GUICtrlListView_GetItemText, it is stored correctly. so only a display limit (still sad tho)

E.

[jchd]

OTOH is it reasonable to expect that a field of length 100K be listed in full in a simple control like ListView?

From any UI point of view this is a no-no.

[guinness]

You could use _WinAPI_PathCompactPathEx in WinAPIEx?

[BrewManNH]

You could use _WinAPI_PathCompactPathEx in WinAPIEx?

Thinking outside the box, I like it. I would never have realized it would work with a simple string as well as a path name to get the results you need, especially considering its name.

[Edano]

hmm, is there a way to make it visible ?

[BrewManNH]

Make what visible?

[czardas]

hmm, is there a way to make it visible ?

 

Write the array to the SciTE console or a txt file.

Edited June 22, 2013 by czardas

[guinness]

Thinking outside the box, I like it. I would never have realized it would work with a simple string as well as a path name to get the results you need, especially considering its name.

There still might be a limitation, so play around with this...

ConsoleWrite(_PathCompactPath(@ScriptFullPath, 10) & @CRLF)

Func _PathCompactPath($sFilePath, $iFlag = 10) ; By AZJIO.
    If StringLen($sFilePath) > $iFlag Then
        Return StringRegExpReplace($sFilePath, '(^.{3,11}\\|.{11})(.*)(\\.{6,27}|.{27})$', '\1...\3')
    EndIf
    Return $sFilePath
EndFunc   ;==>_PathCompactPath

[Edano]

Make what visible?

.

the entire subitem text without truncation IN the listview

Edited June 22, 2013 by Edano

[BrewManNH]

What part of this ENTIRE thread eluded you? No, it's NOT possible because Windows won't allow it.

[Edano]

What part of this ENTIRE thread eluded you? No, it's NOT possible because Windows won't allow it.

.

OK thx

[czardas]

You could try spliting the strings using something like StringEqualSplit and then display them as a number of separate items. It might not work.

Edited June 22, 2013 by czardas

[Edano]

You could try spliting the strings using something like StringEqualSplit and then display them as a number of separate items. It might not work.

.

i tried $LVS_EX_LABELTIP, but the tip is too long to fit the screen ..... same problem.

now i decided to make my own custom tooltip with $LVN_HOTTRACK and splitted item text with @CRLF. that's satisfying.