Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
THIS in a SQL statement
Message
 
 
À
31/07/2009 08:14:28
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2008
Divers
Thread ID:
01415626
Message ID:
01415627
Vues:
78
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform