Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Syntax Error
Message
From
12/08/2012 05:54:15
 
 
To
12/08/2012 04:34:12
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01550355
Message ID:
01550358
Views:
65
My guess is that the line is too long. Try this solution instead, which is also much easier to read.
text to lcQuery pretext 1+2+4+8
SELECT Simain.sino, Simain.invdate, Simain.pcode, Simain.location,
  Simain.cashname, Simain.salesman, Simain.merchand, Sisub.icode,
  Sisub.qntymaj, Sisub.qntymin, Sisub.ratemaj, Sisub.ratemin, Saleprog.zone,
  Kategory.maincat, Kategory.category, Kategory.subcat1, Kategory.subcat2,
  Icode.barcode, Icode.full_desc, Customer.full_name
 FROM 
     vfas!simain 
    INNER JOIN vfas!sisub 
   ON  Simain.sino = Sisub.sino 
    INNER JOIN vfas!saleprog 
   ON  Simain.salesman = Saleprog.salesman 
    INNER JOIN vfas!kategory 
   ON  Sisub.icode = Kategory.icode 
    INNER JOIN vfas!icode 
   ON  Sisub.icode = Icode.icode 
    INNER JOIN vfas!customer 
   ON  Simain.pcode = Customer.pcode 
   WHERE tKategory.mainCat IN(&lcString) AND 
                           tKategory.category IN(&lcString1) AND 
                            tKategory.subCat1 IN(&lcString2) AND 
                            tKategory.subCat2 IN(&lcString3) INTO CURSOR Salqry1 READWRITE

&lcQuery
>Hi,
>
>I am facing a syntax error in the following SQL-Select, but I could not find it please guide..
>
>SELECT Simain.sino, Simain.invdate, Simain.pcode, Simain.location,;
>  Simain.cashname, Simain.salesman, Simain.merchand, Sisub.icode,;
>  Sisub.qntymaj, Sisub.qntymin, Sisub.ratemaj, Sisub.ratemin, Saleprog.zone,;
>  Kategory.maincat, Kategory.category, Kategory.subcat1, Kategory.subcat2,;
>  Icode.barcode, Icode.full_desc, Customer.full_name;
> FROM ;
>     vfas!simain ;
>    INNER JOIN vfas!sisub ;
>   ON  Simain.sino = Sisub.sino ;
>    INNER JOIN vfas!saleprog ;
>   ON  Simain.salesman = Saleprog.salesman ;
>    INNER JOIN vfas!kategory ;
>   ON  Sisub.icode = Kategory.icode ;
>    INNER JOIN vfas!icode ;
>   ON  Sisub.icode = Icode.icode ;
>    INNER JOIN vfas!customer ;
>   ON  Simain.pcode = Customer.pcode ;
>   WHERE tKategory.mainCat IN(&lcString) AND ;
>                           tKategory.category IN(&lcString1) AND ;
>                            tKategory.subCat1 IN(&lcString2) AND ;
>                            tKategory.subCat2 IN(&lcString3) INTO CURSOR Salqry1 READWRITE
>
Previous
Reply
Map
View

Click here to load this message in the networking platform