Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Faster way to fill Array with ADO recordset
Message
From
30/10/2002 09:47:17
 
 
To
25/10/2002 00:45:25
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00715267
Message ID:
00716852
Views:
14
Joao,

Check out File #9916 in the downloads section, it has some code to use GetRows and I believe also transposes the array to arrange it by rows and columns. HTH

>Hi all,
>
>Is there a faster way to fill a array from an ADO recordset than that,
>
>.oRS1=.oConnect.Procura_Geral(lcTable)
>DIMENSION .combobox1.aItems[.oRS1.RecordCount,2]
>.oRS1.MoveFirst
>FOR lni = 1 TO .oRS1.RecordCount
>	.combobox1.aItems[lni,1] = .oRS1.Fields('c_codigo').value
>	.combobox1.aItems[lni,2] = .oRS1.Fields('c_descri').value
>	.oRS1.MoveNext
>NEXT lni
>
>
>Thank's
>
>João Batista
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform