Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grid and Sql Select
Message
De
03/08/1998 19:23:24
Anderson Girardi
Athenas Automação de Escritório
Porto Alegre, Brésil
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Grid and Sql Select
Divers
Thread ID:
00123661
Message ID:
00123661
Vues:
53
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform