Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Syntax
Message
From
11/04/2006 16:17:03
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Syntax
Miscellaneous
Thread ID:
01112490
Message ID:
01112685
Views:
9
>>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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform