Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Two questions about grids
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00892414
Message ID:
00894305
Vues:
14
Hi Edgar

First, it best to have the search createria outside of the grid. Then you can place your refresh code in the valid of the textbox which is outsite of the grid.

IF you need to get value of a field from the grid row, use the rowcolumnchange method of the grid.

>Hello, i have two questions about grids:
>
>1 - i have a grid with the recordsourcetype=Alias and the recordsource=namealias, but i have a textbox where in the interactive method place the next code:
>
>With Thisform
>set deleted on
>*Set step on
> do case
> case .OptOpcion.OptLlamada.value=1
> mivar="%"+alltrim(.text1.value)+"%"
>
> SELECT DISTINCT Llamadas.numero, Llamadas.fllamada,;
> iif(empty(fcierre),"Abierta","Cerrada") as estado,;
> Usuarios_cia.nombre AS usuario, Oficina.nombre AS nombre,;
> Sucursal.nombre AS colegio, Llamadas.detalle,;
> Ingeniero.nombre AS ingeniero;
> FROM helpdesk!llamadas, helpdesk!usuarios_cia, helpdesk!oficina,;
> helpdesk!ingeniero, helpdesk!sucursal;
> WHERE Llamadas.usuario = Usuarios_cia.codigo;
> AND Llamadas.oficina = Oficina.codigo;
> AND Llamadas.ingeniero = Ingeniero.codigo;
> AND Llamadas.sucursal = sucursal.codigo;
> AND str(Llamadas.numero) like mivar;
> ORDER BY Llamadas.numero;
> INTO CURSOR busquedasecllamadas
>
>
> case .OptOpcion.OptUsuario.value=1
> case .OptOpcion.OptColegio.value=1
> endcase
>EndWith
>
>
>But it doesn't refresh the content of the grid, how can i solve this?
>
>2- How can i select the value of the cell in my grid?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform