Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
String gets cut off in a query, the reason?
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
String gets cut off in a query, the reason?
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01072623
Message ID:
01072623
Views:
55
Hi All,

I have the following sql syntax:
SELECT *, ;
[<a href=wc.dll?testProcess~HelloWorld~&bedid=]+transform(bedid)+[~&vacid=]+transform(vacid)+[>]as pagelink;	
FROM vacancies;
WHERE vacancies.bedid = nBedid;
INTO CURSOR tVacancies
For nBedid = 16 the vacid equals 41. I get the follwing string result:
<a href=wc.dll?testProcess~HelloWorld~&bedid=16~&vacid=41
What happened with [>]? What am I doing wrong?

Thanks beforehand
Zakaria al Azhar
My blog on Actuaris.net
Next
Reply
Map
View

Click here to load this message in the networking platform