Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
THIS in a SQL statement
Message
 
 
To
31/07/2009 08:14:28
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2008
Miscellaneous
Thread ID:
01415626
Message ID:
01415627
Views:
80
No it never worked in a select field list. It works in the WHERE and other clauses.
You've to assign the value to a local variable and use it in a query

>I have a SQL statement where I use a class property to populate one of the resultant columns:
>
>select ....., this.objectname.property as ....
>
>it fails with
>Alias "objectname" is not found
>
>Seems to me it worked sometime in the past.
>Am I doing something wrong?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform