FiveTech Software tech support forums

Hello friends!

I need to communicate with a SQL Server.
I create the connection, and do RecordSet:

cSql:="select * from clientes"

oRs:=FW_OpenRecordSet(oCn,cSql)

and I run through the result with:

DO WHILE !oRs:Eof()
..
..

oRs:MoveNext()
ENDDO
oRw:Close()

With MySql I use the "fillarray" and my query is dumped into an array,
in this case, with "FW_OpenRecordSet" you can generate the query directly
in an array??

Thank you so much!

Roberto

Hi,
I think this function is the one you need

aData := RsGetRows( oRs ) // retrive data as array

Excelent!!!!!

Thank you so much!