Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SPT Add Index Number to URL Link
Message
De
18/12/2013 09:26:28
Steven Dyke
Safran Seats USA
Texas, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
SPT Add Index Number to URL Link
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01590583
Message ID:
01590583
Vues:
54
In the following SPT I need to create a url field and have it include the faiindex as a parameter
testconnString = "Select Distinct faiindex, dcrpriorty, csource, partno, complete," +;
		" reqestby, Date(comitdate) As comitdate, comitby," +;
		" Case When csource = 'FAI' Then '<a href=''/QMSWebApp/FAIPrintServlet3.java?p1=''+faiindex+''>'" +;
		" When csource = 'MRR' Then 'See MRR Document' Else comitnote End As comitnote," +;
		" dwgrev, dwgindex, reqrejectd, requestnt" +;
		" From webprddt1.drawmfaie Where complete = 0 And deletedst = 0 And faiindex = 1622138" +;
		" Order By dcrpriorty, Date(comitdate) ASC"
Répondre
Fil
Voir

Click here to load this message in the networking platform