Hi!

First of all, this grid control is just a sample, so do not expect it will be universal and will work in all cases. Anyway, I will give you any help you need to do what you want using that grid class, however, probably you will require to modify code of this class for your needs. In addition, it might be also helpfule for me if we figure out together some sort of bug or another weird thing in the grid ;)

Second, it would be good if I will look to the code and form you made - this way I will be able to quickly determine where is the problem. Can you prepare, zip files and send them to me by EMail, so I will look to this?

Just a suggestion:
In grid only one thing can spoil column settings - assigning the Record Source to the grid in run-time, and grid reconstruction. In my grid class there is a code in RecordSource_Assign and ColumnCount_Assign - when you assign anything to these properties, that code fires to assure all columns have correct header class. In addition, if you have code in the Init event of the grid, put DODEFAULT() there to call my grid class Init event to replace default headers by new headers class.

There are nothing else in this grid class related to the problem you mentioned. Specially, there are no any replacing of the InputMask and Format properties of columns.

When working with related tbales, assure you have alis ("Alias.Field") in the control source of the grid columns.

Again, do you assign RecordSource to the grid in run-time? It looks like that.

To see if sorting works, just put SET STEP ON in the CLICK method in the SortHeader.PRG and tell if that method fire at all. If fire, comment out the ON ERROR statements in the SortIt method in that PRG and see what error message will be displayed.

Do not know about SET RELATION. It looks strange for me that column values are not displayed accordingly to the related table values. Is the table you're displaying in the grid also a child of another table?

HTH.

>Hi,
> Vlad the settings are not lost. You did not get my problem. Problem i am facing is -
>a) I have setup all formats and input mask for each currency column in the grid.
>
>

Pls Note : I have 4 currency columns being displayed in sortgrid.

>
>b) When i execute the form using your sortgrid class - the currency symbol does not appear in any of the column.
>
>c) When i click on the first currency column - the currency symbol for that cell appears and if i move my cursor one row up or down the rest of the cells in the same column appear with currency symbol.
>
>d) The other 3 columns on which i havent yet clicked appear without currency symbol but the moment i click on any of them i will see the currency symbol for that entire column.
>
>e) Also your grid seems to have RELATION problem. I am having 15 columns in the grid displaying information from 10 tables. The first 10 columns are displaying values from (foreign tables or other tables) which are linked to the Grids recordsource. When the form is executed, the sortgrid displays information correctly. Now when u click on the cell in the first column of the grid the following happens
> 1) the clicked cell value is shown in all cells in that column.
> 2) the other linked cells which r showing values become blank.
> 3) When I do NEXT - Previous on the form all the information is displayed back correctly.
>
> BTW the sorting feature of the sortgrid does not work on any of the linked columns.
>
>sanjay.
>
>
>
>
>
>>Hi!
>>
>>This grid has nothing to currency fields. You require to set up the input mask and format for all currency columns (to display grid rows) AND control inside all currency columns (for current cell). You can do it in the loop in the Init event of the grid.
>>
>>If you meant your settings are lost by some way, let me know - this is another problem in VFP grids.
>>
>>>Hi Vlad,
>>> i was using your grid (from SortGrid.Zip) and i am having following problem -
>>>Currency Fields - do not get refreshed. When the form is executed first time the column in grid with currency field appears as a plain numeric field. I have given a column format mask of '$' but when u click on the cell in that column than the currency symbol appears for the entire column and not other (currency) columns.