1) How to SAVE without closing the table

2) When going over a column name that does not match (letter numeric) you get a message .. but the if there are .. say 3 in a row and you page up to the 2nd one . you get into a loop which is very hard to break

3) How do we add a column to view. In Calculated fields we want to see the conversions.

4) Why can't we change info in the tables .. why do we have to go to a secondary screen.

5) Tablebuilder allows creation of dict IDS that are number .. for example 1, 10 etc. This is a standard behaviour in PICK (AND ALL PICK-a-likes) but RLIST (select list etc) is not capable of using these fields.

6) When viewing a table in the 'Table Builder' it LOCKS the table so no changes in Form Designer. How can we 'unlock' the table but still be able to 'VIEW' the dictionary?

7) Shouldn't we be able to manage indexes from Tablebuilder? How hard would it be?

Sig-

The TB is my area of responsibility, but I'm somewhere in the carribbean right now (what a world we live in, huh?) and don't know the specific answers.

From memory, I don't think you can save without closing, but that should be easily fixable.

Numeric column filed names might be restricted by dict.mfs, but I'm not sure.

Indexes are probably manageable, but I think we hit a locking issue IIRC.

I'll look at the other items and respond more cogently when I get back.

Mike

hmmm .. thanks for the response .. but didn't need to know you were in the Carribean hard life Must be some time off after Specturm and all those PICK guys

dsig _at_ sigafoos.org.com onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"

David Tod Sigafoos ~ SigSolutions

It would be nice if the F types can be sorted by Row Name as well as FMC. Makes finding a specific dictionary item easier in humongous (humungous?) dictionaries. I meant to enter this into the enhancement requests but laziness intervened…

Yep .. just make table 'sortable' by column .. then a daffy user could sort by length if 'i' wanted to

dsig _at_ sigafoos.org.com onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"

David Tod Sigafoos ~ SigSolutions

Once you've clicked in either the data or calculated column grids, you can press Crtl-F3 and do a search…

Cool :)

Thanks

but searching for a field and viewing the dict BY field name is not really the same thing.

This AND the ability to use TB in 'UNLOCK' mode would be very handy in some instances ..

dsig _at_ sigafoos.org.com onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"

David Tod Sigafoos ~ SigSolutions

Yeah, sort by Row name would still be nice.

I haven't tried it yet so it may do it now, but searching for text within the symbolic code across all symbolics would be nice too.

And another thing ..

You should be able to create tables to another application. Quite often we create tables as 'GLOBAL' and through tableBuilder this is not *possilbe*. Have to create the table then change the media map .. oh my

dsig _at_ sigafoos.org.com onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"

David Tod Sigafoos ~ SigSolutions

or COPY_TABLE but yes, it is a pain :)

support@sprezzatura.com

The Sprezzatura Group Web Site

World Leaders in all things RevSoft

You are of course correct .. but since CREATE_TALBE allows it it would be nice if the front end was at least as flexible.

dsig _at_ sigafoos.org.com onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"

David Tod Sigafoos ~ SigSolutions

Sig-

Answers follow.

1. As you move from row to row in the tool it saves automatically, so perhaps the save button should be renamed close.

2. In process- working on it right now.

3. Users cannot modify the columns that are visible. I can add the conversions if there is a call for it.

4. I don't understand this questions- can you clarify.

5. It looks like this is a Rlist limitation, limited by the ability to do a LIST 10 CUST etc. I don't think we'll be able to change it.

6. We lock the %FIELDS% field and then individual fields as we work on them. If you open the formdes first, then the TB, you can view without making changes in the TB.

7. It is doable, but not in this release.

8. We've modified the TB_NEW_TABLE screen to let you specify the application; it defaults to the current application.

Mike

DSig]1) How to SAVE without closing the table

MR] 1. As you move from row to row in the tool it saves automatically, so perhaps the save button should be renamed close.

Really .. hummm .. so if you don't want the changes ..

DSig]2) When going over a column name that does not match (letter numeric) you get a message .. but the if there are .. say 3 in a row and you page up to the 2nd one . you get into a loop which is very hard to break

MR] 2. In process- working on it right now.

COOL ..

DSig]3) How do we add a column to view. In Calculated fields we want to see the conversions.

MR] 3. Users cannot modify the columns that are visible. I can add the conversions if there is a call for it.

'i' think this would be great .. the less you have to move from one screen to another .. the more productive you are .. wait .. where did I put that mouse

DSig]4) Why can't we change info in the tables .. why do we have to go to a secondary screen.

MR] 4. I don't understand this questions- can you clarify.

This is more of #3 .. The ability to have this all table driven. More colums to the right .. scroll if we want .. or DCLICK and go into the secondary screen for the details.

We are currently working on a conversion of a PICK system .. Lots and Lots of tables/columns although our dict conversion routine works pretty sweet .. still have to review and smudge by hand. going in and out of the 'detail' window is a pain in the …

DSig]5) Tablebuilder allows creation of dict IDS that are number .. for example 1, 10 etc. This is a standard behaviour in PICK (AND ALL PICK-a-likes) but RLIST (select list etc) is not capable of using these fields.

MR] 5. It looks like this is a Rlist limitation, limited by the ability to do a LIST 10 CUST etc. I don't think we'll be able to change it.

must be why other MVs use a 'sampling' keyword

DSig]6) When viewing a table in the 'Table Builder' it LOCKS the table so no changes in Form Designer. How can we 'unlock' the table but still be able to 'VIEW' the dictionary?

MR] 6. We lock the %FIELDS% field and then individual fields as we work on them. If you open the formdes first, then the TB, you can view without making changes in the TB.

Okay .. we will make sure we do it that way

DSig]7) Shouldn't we be able to manage indexes from Tablebuilder? How hard would it be?

MR] 7. It is doable, but not in this release.

Cool .. please put it on the list with the other 4zillion odd things I ask for

MR] 8. We've modified the TB_NEW_TABLE screen to let you specify the application; it defaults to the current application.

WAY COOL!!!!!

thanks a lot ..

dsig _at_ sigafoos.org.com onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"

David Tod Sigafoos ~ SigSolutions

dsig _at_ sigafoos.org.com onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"

David Tod Sigafoos ~ SigSolutions

Along with #7 (managing indexes from table builder and more columns on the table ..

could you make it possible to change Master/Syn easier. There must be a way to just change it in Table Mode ..

I know this last one isn't a problem most of the time unless you are importing systems. PICK-A-LIKES really like having a bazzillion dicts per field .. and going through them are a PAIN .. you need them all cause the idiots (oops) use them all .. but A3 is not an intuitive 'Master' field .. but if it is the first one in the import write .. there you go.

Thanks again

View this thread on the Works forum...