Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SPT Add Index Number to URL Link
Message
From
18/12/2013 09:26:28
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SPT Add Index Number to URL Link
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01590583
Message ID:
01590583
Views:
53
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"
Reply
Map
View

Click here to load this message in the networking platform