Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
THIS in a SQL statement
Message
From
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:
01415636
Views:
60
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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform