General information
Category:
Coding, syntax & commands
Hi All
I try to run this query but I always get this error
SQL: Column stvqp1 is not found
I have made this query in the query designer and it work just fine
I copy it in my code and replace the table name with lsolde and llivre
lpath = Thisform.prppath && 'c:\Avantage Win\Ava01\
lSolde = Thisform.prppath+"Solde.dbf'
lLivre = Thisform.prppath+"Livre.dbf'
SELECT Solde.stpsp,Solde.stvqp1,Livre.lnum,; Livre.lnom,Livre.lnoma,Livre_a.lnum, Livre_a.lnom,Livre_a.lnoma;
FROM(lSolde) as Solde ;
LEFT OUTER JOIN (lLivre);
LEFT OUTER JOIN (llivre) Livre_a ;
ON Solde.stvqp1 = Livre_a.lnum ;
ON Solde.stpsp = Livre.lnum INTO CURSOR cGltaxe
any tip's
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