Information générale
Catégorie:
Codage, syntaxe et commandes
>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
Do not use 'INTO CURSOR' with RecordSourceType=4.
If you want to acces the cursor while you are runing the form,than first run the SQL statement wih 'INTO CURSOR PESQUISA' and then set the RecordSourceTupe property to 1, and the RecordSource to the desired alias ('PESQUISA')
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement