General information
Category:
Coding, syntax & commands
Title:
Grid and Sql Select
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only