Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select-SQL
Message
 
To
13/04/2005 23:15:47
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
01004461
Message ID:
01004489
Views:
14
>I have a grid to show a table. Is that possible to make Select-SQL statement more "Updated" before i run TABLEUPDATE(.T.) command? What i try to mention is, when i change some uncomfirm data to my table(update or replace), the grid will show the old-data,but wat i want is new data without run TABLEUPDATE(.T.). I use CURSORSETPROP('buffering',5). Is that any idea. sorry for poor english.Thank you!
>
>Problem 2:
>Is that anyway to make the grid will highlight entire row, not only a columnin in a row.
>Is that possible for someting like---Thisform.grid1.selecteditem.column1.text.value or other way to get the highlighted value? Thanks..
>
>Sean

What are you using for RecordSource in a grid?
I use grids everywhere in my application and have no problems with the data that showed in the grid, no metter if I use Buffering=5 or not, the Grid always shows last data I (user) enter.

2. What version of VFP you use? It is a good idea when you create a new message to poin the version of VFP you use.
If you use VFP 8 (I am not sure abou VFP7) or latter look at HightLightStyle property of the grid.
If you are using smaller the 8 version here in download section Download # 9798 there is a class named Grid Highlighter.

To get the current HighLighted value of the grid, you can do:
add a property in the form named CurrentGridColumn
In AfterRowColChange event of the grid put:
thisform.CurrentGridColumn = nColIndex
You can get the value of the HightLighted row this way:
 IF UPPER(thisform.Grid1.RecordSource)+"." $ thisform.Grid1.Columns(thisform.CurrentGridColumn).CountrolSource
    cCurrentValue = thisform.Grid1.Columns(thisform.CurrentGridColumn).CountrolSource
 ELSE
    cCurrentValue = thisform.Grid1.RecordSource)+"." + thisform.Grid1.Columns(thisform.CurrentGridColumn).CountrolSource
 ENDIF
 eCurrentValue = &cCurrentValue
something like that (not tested)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform