Garret,

>>>

An Exercise in Futility

>>
>>Can't you even spell right? I would suggest that you make your speelling errors in small type not

big type

, it makes them harder to spot :-)
>
>Sorry, Jim, I spotted it anyway. :-)
>
>BTW, anyway else remember the SET/CREATE VIEW command? I don't think I've seen it mentioned this thread...

Yep, I remember, but it's not quite where i was aiming for. I did want to hide the complexity completely; thus also in the datasession window.

However I did find another interesting command which takes it a step further:
the SET FIELD command:

SET FIELD TO Alias1.field1, alias1.field2, alias2.field1, alias3.field1 etc.

You can create a view in the way I described but you've got to address the field by their alias when replacing etc.

However if you want to display certain columns with for example the ? command you would not need the alias prefix. This also seems to work in a grid.

I really like to see a possibility to abstract the whole thing a bit more so I will be able to adress all fields under the same alias. And of course I want to be able to use the whole in a SQL command also.

But since nobody seems to see the benifit of it, it will likely never happen...

Regards,

Walter,