General information
Category:
Coding, syntax & commands
Hello!
I'm doing a form where i have i grid object and the recordsource property is a sql select command:
ThisForm.Grid1.RecordSourceType = 4
ThisForm.Grid1.RecordSource = "SELECT DISTINCT Nota.cod_nota, Nota.nota_num, Nota.razao_soc,;
Prodnota.cod_prod, Produtos.desc_prod;
FROM poadesp!nota, poadesp!prodnota, poadesp!forneced, poadesp!produtos;
WHERE ALLTRIM(ProdNOTA.cod_prod) = ALLTRIM(PRODUTO);
AND PRODUTOS.COD_PROD = PRODNOTA.COD_PROD;
AND Prodnota.cod_nota = Nota.cod_nota;
INTO CURSOR PESQUISA"
But the vfp shows me a message saying "Sintax Error"
Anyone knows where is the wrong?
Thank
Anderson Reis Girardi
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