Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 To: Bapi Roy
  Where is Bapi Roy?
 Alipurduar
 India
 Bapi Roy
 Tags
Subject: RE: What's the problem with my View?
Thread ID: 228462 Message ID: 228463 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: General VFP Topics
Date: Tuesday, May 19, 2009 8:09:32 AM         
   


> && Variable
> lnSId = 2
> lcPo = "APD"
>
>
> && View Payslip
> CREATE SQL VIEW viewpayslip AS SELECT Workers.jcn, Workers.account, Workers.name, Payements.attend,;
> Payements.amount, Works.workrate, Workers.po FROM gpm!payements ;
> INNER JOIN gpm!workers ON Payements.wkridf = Workers.wkridx INNER JOIN gpm!works ;
> ON Payements.wkidxf = Works.wkidx WHERE Works.wkidx = lnSId;
> AND Workers.po = lcPo;
> ORDER BY Workers.account asc
>
> when I execute this code it create a view with variable name in place of variable value.
>
> I need this view created before in generate report.
>
> What is the problem in my view ?

Use ?lnSId instead of lnSId

Regards
Tushar

ENTIRE THREAD

What's the problem with my View? Posted by Bapi Roy @ 5/19/2009 8:08:17 AM
RE: What's the problem with my View? Posted by tushar @ 5/19/2009 8:09:32 AM
RE: What's the problem with my View? Posted by Bapi Roy @ 5/19/2009 8:14:49 AM
RE: What's the problem with my View? Posted by Borislav Borissov @ 5/19/2009 9:06:23 AM
RE: What's the problem with my View? Posted by Stefan Wuebbe @ 5/19/2009 10:39:35 AM
RE: What's the problem with my View? Posted by Bapi Roy @ 5/21/2009 4:10:20 PM