Why a can not use the .list statement..

[sal21]

part of code

Code: Select all

...
strDBRows = RST0.GetRows
  RST0.Close

  Me.ORDINE.Clear
  Me.ORDINE.AddItem "TUTTI"
  
  'Me.ORDINE.List = strDBRows(1, I) & " - " & strDBRows(0, I)
  
  For I = 0 To UBound(strDBRows, 2)
    Me.ORDINE.AddItem Format(strDBRows(1, I), "#0000") & " - " & strDBRows(0, I)
    CONTA = CONTA + 1
  Next I
..

why instaed to loop with for next i cannot use the .list statement to fill the combobox.ORDINE in "one shot only"

Based :

[HansV]

strDBRows(1, I) and strDBRows(0, I) are single values, not arrays.

[sal21]

strDBRows(1, I) and strDBRows(0, I) are single values, not arrays.

in my case how to fill the combobox.ORDINE in "one shot only" with strDBRows = RST0.GetRows???

note:
My query select, inother case 2 fileds and assign via getrow to strDBRows.

[HansV]

Is this in Excel or in VB6?

[sal21]

Is this in Excel or in VB6?

in VB6..

note:
Sorrym me on my stupid question and tks for your patience

[HansV]

I think you'll have to loop since the result of GetRows is an array with the columns in the first dimension and the rows in the second dimension.
The List property of a list box or combo box is an array with the rows in the first dimension and the columns in the second dimension.

Excel has a Transpose method, but VB6 hasn't...

[Becks]

See http://support.microsoft.com/kb/246335 for a function to Transpose your dataset

Kevin