Someone has an example of the use of a recorset with xbrowse

Posts: 1816

Joined: Wed Oct 26, 2005 02:49 PM

Someone has an example of the use of a recorset with xbrowse
Posted: Tue Feb 19, 2008 05:30 PM

thanks nageswaragunupudi

Thank you very much for the help. It works of marvel.

But have I another question?

Since I do to update the recorset. for example that wants to change the order that estan showing the consultation.

The initial recorset is:

Code: Select all Collapse

oVar   := "SELECT * from colores order by CODIGO"
TRY
  oLamcla:oRsColore:=tOleAuto():New("ADODB.RecordSet")
CATCH oError
  MsgStop( "No se ha podido crear el RECORDSET !","Error de Datos" )
END

oLamcla:oRsColore:CursorLocation  := adUseClient //adUseServer
oLamcla:oRsColore:LockType        := adLockOptimistic
oLamcla:oRsColore:CursorType      := adOpenKeyset
oLamcla:oRsColore:Source          := oVar
oLamcla:oRsColore:ActiveConnection( oLamcla:oServer )

But I want to update the recorset with the following consultation:

Code: Select all Collapse

oVar   := "SELECT * from colores order by NOMBRE"

Since I do it?

In advance thank you for the answer.

Saludos
LEANDRO AREVALO
Bogotá (Colombia)
https://hymlyma.com
https://hymplus.com/
leandroalfonso111@gmail.com
leandroalfonso111@hotmail.com

[ Turbo Incremental Link64 6.98 Embarcadero 7.70 ] [ FiveWin 25.01 ] [ xHarbour 64 bits) ]

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Someone has an example of the use of a recorset with xbrowse
Posted: Tue Feb 19, 2008 05:58 PM

After reading the recordset in any order, whenever you want to change the order of the recordset, simply say :

Code: Select all Collapse

oRs:Sort := "NOMBRE"
oBrw:Refresh()

Now please confirm to me that your browses even with empty recordsets are working with the above code I gave you? If you confirm, we shall draft a neat replacement and suggest to Mr Antonio to incorporate in the next release

Regards

G. N. Rao.

Hyderabad, India

leandro

Posts: 1816

Joined: Wed Oct 26, 2005 02:49 PM

working...
Posted: Tue Feb 19, 2008 06:13 PM

Clear friend that if it of the recoset I work perfectly with the example that gave me. Thanks

With regard to it of the update of the recorset ... since I do to do filters or searches inside the table?

Saludos
LEANDRO AREVALO
Bogotá (Colombia)
https://hymlyma.com
https://hymplus.com/
leandroalfonso111@gmail.com
leandroalfonso111@hotmail.com

[ Turbo Incremental Link64 6.98 Embarcadero 7.70 ] [ FiveWin 25.01 ] [ xHarbour 64 bits) ]

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Someone has an example of the use of a recorset with xbrowse
Posted: Tue Feb 19, 2008 06:16 PM

>
With regard to it of the update of the recorset ... since I do to do filters or searches inside the table?
>

you can

Regards

G. N. Rao.

Hyderabad, India

leandro

Posts: 1816

Joined: Wed Oct 26, 2005 02:49 PM

Someone has an example of the use of a recorset with xbrowse
Posted: Tue Feb 19, 2008 06:48 PM

jajajajaja Not understan that I must do jajajaja

Saludos
LEANDRO AREVALO
Bogotá (Colombia)
https://hymlyma.com
https://hymplus.com/
leandroalfonso111@gmail.com
leandroalfonso111@hotmail.com

[ Turbo Incremental Link64 6.98 Embarcadero 7.70 ] [ FiveWin 25.01 ] [ xHarbour 64 bits) ]

FiveTech Support Forums

Continue the discussion