Very Computer

Does anyone know how I can keep the leftmost column on a forms table frame
from disappearing when I scroll to the right?  I would like that column to
stay in place at all times so I can see the value in it but I have a lot of
fields on in the table frame.  Is there a way to do that?

Thanks in advance

-Bruce

Bruce,

As I recall, I believe the solution lies in placing two Table Frames
(showing different fields) in the same form, linking each TF to a
different AliasName (ASourceTable, BSourceTable) on the same table.
You can equalize the size of visual objects with the Align toolbar
objects and/or with the Object Explorer, Appearance tab (directly
key in the dimensions).  Use the resync methods to keep both TF's
displaying the same record.

Other have asked this question, but I don't remember what keywords
to look for in the NG's.

    -- GeneM

Bruce,
From one of Liz's posts:
Put your cursor in the second column of your tableframe while the form is
running.  Press Ctrl+R - keep doing this until you understand what's going
on...
Note that the first column stays put while the others rotate.  Put your
cursor
in the first column and press Ctrl+R and all the columns will rotate...

The code to simulate this would be...

active.action(FieldRotate)

...where the object name (or active) is required.
Peter...

--
Peter...

Quote:> Bruce,

> As I recall, I believe the solution lies in placing two Table Frames
> (showing different fields) in the same form, linking each TF to a
> different AliasName (ASourceTable, BSourceTable) on the same table.
> You can equalize the size of visual objects with the Align toolbar
> objects and/or with the Object Explorer, Appearance tab (directly
> key in the dimensions).  Use the resync methods to keep both TF's
> displaying the same record.

> Other have asked this question, but I don't remember what keywords
> to look for in the NG's.

>     -- GeneM

Bruce,

See Ivica Kolar's "Free Permuting TableFrame Columns" form. It's free and with
full source. Available at http://cust.east.ru/~menkin/

   Vladimir Menkin

All these are greate suggestions!  I'm testing them all to see which one
works the best.  I'll let you know what I find out.

Thank you very much!

-Bruce

There's a FAQ on this...well, I thought there was !

This is the text I retained:

Often, people ask how to make a tableFrame behave like a
tableView, in that you can freeze some columns at the left of .a
TV

Arrange your two table frames beside each other so they look
like one (cosmetics !).  Call the frozen one "tfStatic and the
other one tfDynamic.

Enclose them in a box, and declare two uiObjects in the Var of
the box - uiStaticTF and uiDynamicTF. In the open() of the box,
attach the uiObjects to their tableFrames.

In the action() of each of the tableFrames place code that traps
all the necessary actions (DataBegin, DataEnd, DataFastForward,
DataNextRecord, .....), does a doDefault, and applies the same
action to the other uiObject. This is for tfDynamic :

if eventInfo.id() = DataBegin or
   eventInfo.id() = DataEnd or .....
then
   doDefault
   uiStaticTF.postAction(eventInfo.id())
endif

This should keep things in sync.

hth

Mike

PS I found it - it's in the Forms Tip of Paradox Tips on my own
site - http://mirwin.homestead.com

Quote:> Does anyone know how I can keep the leftmost column on a forms table frame
> from disappearing when I scroll to the right?  I would like that column to
> stay in place at all times so I can see the value in it but I have a lot of
> fields on in the table frame.  Is there a way to do that?

> Thanks in advance

> -Bruce