FiveTech 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!