Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Comparison amongst Grid cells
Message
From
13/11/2001 03:09:02
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
12/11/2001 23:11:53
Ransome So
Ransome's Workshop
Hong Kong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00580724
Message ID:
00580762
Views:
19
>Dear all,
>
>In my design, a grid host a table which show the range of a control field:
>
>Column1 Column2 Column3
>control field Range from Range to
>---------------------------------------------
>A 10000 19999
>B 20000 39999
>C 40000 89999
>
>I edit the grid by a commandbutton EditItem which set theGrid.readonly to .f.
>
>How can I do that when I lost focus from colum2 or column3, It compare the value of the cell with the record before and after, say if the column2 of control field is <20000, a prompt warns me to check the entry.
>
>Wit regards,
>
>Ransome
So,
Thinking this is buffered if applicable use an array. So you can check :

if this.RowId > 1 and this.Value <= thisform.arrCheck[this.RowId-1,2]

if this.RowId < MaxRows and this.Value > thisform.arrCheck[this.RowId+1,1]

thisform.arrCheck[this.RowId,1] = this.value && Or 2
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform