Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Christian Tabligan
  Where is Christian Tabligan?
 Bacolod City, Neg. Occ.
 Philippines
 Christian Tabligan
 To: ven chin
  Where is ven chin?
 
 Singapore
 ven chin
 Tags
Subject: RE: invalid sub query
Thread ID: 228579 Message ID: 228603 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: Databases, Tables and SQL Server
Date: Wednesday, May 20, 2009 8:13:11 AM         
   


> >
> > Did you tried running your code in VFP version 9?
> >
> > Best Regards,
> >
> > CriZ (,")
> >
> > "Happiness is real when shared."
>
> Dear Criz,
>
> No, due to we have VFP8 in the office only

I have no idea If the preceding (Select) statement after INNER JOIN is supported in version 8. Why don't you put your subquery into another cursor

like...

SELECT portcode,desc as desc FROM portcode into cursor Temp

...
...
INNER JOIN Temp ON d.origin = Temp.portcode INTO CURSOR ViewAttach  

or 

SELECT h.custcode+h.custcode+h.vslcode+h.voycode+h.cbound as BatchID, c.cust_cn, h.vslname, h.voycode, h.cbound, ; h.invdate, d.etapol, d.origin, d.pol, d.pod, d.deliveryp, ;
IIF(d.origin = portcode.portcode), desc, "") as origin, ;
IIF(d.dest= portcode.portcode, desc, " ") as dest, ;
d.blno, d.equiptype, d.qty, 'P' as freight, d.chrgcode, IIF(d.chrgccy = 'THC','CNY',d.chrgccy) as chrgccy, ; d.chrgrate, IIF(d.chrgccy = 'USD', d.amt, 0.00) as usdamt, IIF(d.chrgccy <> 'USD', d.amt, 0.00) as rmbamt ;
FROM local_invh h INNER JOIN local_invd d ON h.invno = d.invno ;
INNER JOIN customer c ON h.custcode = c.custcode ;
WHERE h.invdate = lcInvDate ;
ORDER BY BatchID, d.origin, d.pol, d.pod, d.deliveryp, d.blno ;
INTO CURSOR ViewAttach


Best Regards,

CriZ (,")

"Happiness is real when shared."

ENTIRE THREAD

invalid sub query Posted by ven chin @ 5/20/2009 3:33:14 AM
RE: invalid sub query Posted by Christian Tabligan @ 5/20/2009 4:13:28 AM
RE: invalid sub query Posted by ven chin @ 5/20/2009 7:26:09 AM
RE: invalid sub query Posted by Christian Tabligan @ 5/20/2009 8:13:11 AM
RE: invalid sub query Posted by Derrick Bruce @ 5/20/2009 6:01:59 AM
RE: invalid sub query Posted by ven chin @ 5/20/2009 6:18:25 AM
RE: invalid sub query Posted by Derrick Bruce @ 5/20/2009 6:39:58 AM
RE: invalid sub query Posted by ven chin @ 5/20/2009 7:25:26 AM
RE: invalid sub query Posted by Anders Altberg @ 5/20/2009 10:57:36 AM
RE: invalid sub query Posted by Derrick Bruce @ 5/20/2009 8:37:39 PM