Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
THIS in a SQL statement
Message
 
 
To
31/07/2009 09:08:11
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:
01416060
Views:
65
You're welcome

>I see, thanks.
>
>>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
Reply
Map
View

Click here to load this message in the networking platform