Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Passing parameter in Query
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Passing parameter in Query
Divers
Thread ID:
00823263
Message ID:
00823263
Vues:
52
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform