ADO for SQL Server and Array

ADO for SQL Server and Array

Postby TOTOVIOTTI » Wed Jul 31, 2024 11:13 am

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
Univ@c I.S.I.
Desarrolladores de Software
http://www.elcolegioencasa.edu.ar
User avatar
TOTOVIOTTI
 
Posts: 419
Joined: Fri Feb 05, 2010 11:30 am
Location: San Francisco - Córdoba - Argentina

Re: ADO for SQL Server and Array

Postby Jack » Wed Jul 31, 2024 12:30 pm

Hi,
I think this function is the one you need

aData := RsGetRows( oRs ) // retrive data as array
Jack
 
Posts: 288
Joined: Wed Jul 11, 2007 11:06 am

Re: ADO for SQL Server and Array

Postby TOTOVIOTTI » Wed Jul 31, 2024 12:41 pm

Excelent!!!!!

Thank you so much!
Univ@c I.S.I.
Desarrolladores de Software
http://www.elcolegioencasa.edu.ar
User avatar
TOTOVIOTTI
 
Posts: 419
Joined: Fri Feb 05, 2010 11:30 am
Location: San Francisco - Córdoba - Argentina


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 55 guests

cron