Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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,
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement