> Hello All, anyone here do a Sql Select and show her result in a Grid
>Object?
>
> By sample, i want do a query in a table be determinate date
>M.Dataini=21/07/1998 and M.DataFim= 21/10/1998, i have the follow sintaxe:
>
>SELECT Parcela.valorrec, Parcela.datavenc, Parcela.codigo, Cliente.nome,;
> Cliente.endereco, Cliente.bairro, Cliente.cidade, Cliente.estado,;
> Cliente.cep, Cliente.rg, Cliente.cic;
> FROM banco!parcela INNER JOIN banco!vendas;
> INNER JOIN banco!cliente ;
> ON Vendas.codcli = Cliente.codigo ;
> ON Parcela.codvenda = Vendas.codigo;
> WHERE Parcela.datavenc BETWEEN M.dataini AND M.datafim;
> ORDER BY Cliente.nome;
> INTO Cursor cCobTit
>
>But when a do this query the grid object is disabled, there's any soluction
>this trouble?
>
>Thanks
The problem is probably the location of your code. To base a grid on a cursor, create the cursor, and then set the grid's recordsource.
SELECT blah blah blah
INTO CURSOR MyCursor
thisform.mygrid1.recordsourcetype = 1 && Alias
thisform.mygrid1.recordsource = 'MyCursor'
thisform.mygrid1.refresh()
Erik Moore
Clientelligence