Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Syntax
Message
De
11/04/2006 16:17:03
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Re: Syntax
Divers
Thread ID:
01112490
Message ID:
01112685
Vues:
10
>>Can someone help me with the correct syntax for this sequence for a grid in a custom container?
>>
>>
>>this._year = curryear + this.yearsadd
>>this.sourcetable = "year1"
>>
>>use (addbs(fileloc) + this.originaltable) in 0 again alias (this.sourcetable) order tip_id
>>
>>select (this.sourcetable)
>local lcFilter
>lcFilter = [year = ] + alltrim(str(this._year))
>*>set filter to year = this._year    && this is the problem line
>set filter to &lcFilter
>>
>>this.grid1.RecordSourceType = 1
>>this.grid1.RecordSource = this.sourcetable
>>this.grid1.column1.ControlSource = this.sourcetable + ".amount"
>>this.grid1.column2.ControlSource = this.sourcetable + ".source"
>>this.grid1.column3.controlsource = this.sourcetable + ".phase"
>>
>>
>>this._year is a property of the class and has public visibility but the filter statement fails anyway.

The square bracket [] is new to me. What does it do and how is it different from framing the fieldname in quotes?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform