Subject Re: Column Sequence in Grid
From Peter Hegelbach <peter@hegelbach.com>
Date Tue, 20 Sep 2022 23:00:21 +0200
Newsgroups dbase.getting-started
Attachment(s) Sampe FilterGrid.zipScreenshot Gridsetup.pngScreenshot Gridset.png

Hi Daniel

A short explanation first:
for any user, client and grid a save the settings in a database (in my
case ms sql). Also all fields must be registered with name, type and so
on. User 0 ist the presetting.

>> how do you handle the "filter bar", if the grid is wider then
>> the window (horizontal scrolling)?

I don't do much. If the grid is longer, part of it is not shown.

>> How do you change the columns "on the fly" without reopening the
>> form? Do you create a new grid?

Yes. I delete the old grid an build a new one. See function
PH_FilterGrid::myinit(iUserFID, iClientFID)

In the ZIP-File is hopefully all, what you need to analyze. Otherwise aks.

Peter


Am 20.09.2022 um 14:20 schrieb Daniel Georgi:
> Am 19.09.2022 um 22:22 schrieb Peter Hegelbach:
>> Do you mean something like this (in the video)?
>>
>> Once I had a project called filterGrid, which was able to select
>> columns, change order and save seperately for every user. Lot of code,
>> so first only a video:
>>
>> https://vimeo.com/751392896/6ce7bd5c1b
>>
>> Peter
>>
>>
>> Am 16.09.2022 um 18:25 schrieb Milind Nighojkar:
>>> Is there any way to change the column sequence in a grid (not by drag
>>> and drop menthod.) thru code before openingĀ  a form.
>>>
>>> Example : Say column 3 is date filed and should me moved to column 5
>>> and column 5 to col 3.
>>>
>>> Regards
>>>
>>> Milind Nighojkar
>>
>
> Hello Peter,
>
> how do you handle the "filter bar", if the grid is wider then the window
> (horizontal scrolling)?
>
> How do you change the columns "on the fly" without reopening the form?
> Do you create a new grid?
>
> Thanks
> Daniel
>