Mr Rao
You can help me please , I use RecSet, but not work correctly, see you this example: I used MaeiaDb
You can help me please , I use RecSet, but not work correctly, see you this example: I used MaeiaDb
Function ListaUser(oCn)
local lOK, cData, oData, aRet := {}
lOk := .t.
cData := "SELECT nick FROM usuarios ORDER BY nick"
TRY
 oData := oCn:RecSet( cData )
CATCH
 lOK := .f.
END
If lOk
 xbrowse(oData)
 WHILE !oData:EOF()  // <--------- :EOF(), BOF()  With :RecSet not working, with RowSet  is Ok
  AADD(aRet, oData:nick )
  oData:Skip()
 ENDDO
EndIf
Return(aRet)