Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Passing parameter in Query
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Passing parameter in Query
Miscellaneous
Thread ID:
00823263
Message ID:
00823263
Views:
50
Guys
i have trouble in querying data..
I want to pass parameter in it...
this is the samples..
LOCAL mmIN,LY,XACT,XTM,Q
actualtabletahunan = 'ATRJLN03'    &&====>yearly table (dynamic)
MMin = actualtabletahunan+".k_insp"
LY = "vrtm_Actualjalan.k_insp"
XACT =maproot+"tables\&actualtabletahunan"
XTM=maproot+"tables\vrtm_actualjalan"
Q="SELECT DISTINCT vrtm_actualjalan.* FROM "+XACT+" INNER JOIN "+XTM+;
" ON "+MMIN+" = Vrtm_actualjalan.k_insp WHERE !DELETED() AND MONTH(Vrtm_actualjalan.tgl_Act)="+;
ALLTRIM(STR(nbulan))+" AND YEAR(Vrtm_actualjalan.tgl_act)="+ALLTRIM(STR(ntahun))+" AND vrtm_actualjalan.PT='"+;
ALLTRIM(KODEPT)+"' ORDER BY vrtm_actualjalan.K_insp INTO TABLE tables\reports\rt_progresjalan.dbf"

&Q       
With that kind of query it did works in designer

but after i compile it...

It become error in '&Q', says command unrecognize......

How to fix the problem...
thx...
The More We give, the more we earn
Next
Reply
Map
View

Click here to load this message in the networking platform