On 11/13/05, <b class="gmail_sendername">Jarosław Staniek</b> <<a href="mailto:js@iidea.pl">js@iidea.pl</a>> wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Cornelius Schumacher said the following, On 2005-11-14 00:52:<br><br>> On Monday 14 November 2005 00:26, Jaroslaw Staniek wrote:<br>><br>>>-Since certain database backends may require latin1 identifiers, these are
<br>>>created implicity for level 1 (user do not know about this).<br>><br>><br>> Why would any user want to explitcitly give identifiers when they can be<br>> created implicitly?<br><br>See my answer to Robert Knight for more info.
<br><br>> This doesn't sound like a good reason for user levels,<br>> but as a good reason to remove some complexity from the user interface.<br><br>To fully understand this need, you need to look how database tables/queries/
<br>etc. are named in a real-world database (or data warehouse) applications:<br><br>e.g. you can encounter very descriptive names like "Annual report for<br>medicines" table name. One user may want to use this long the name in SQL
<br>statements and scripts, other do not want this and want to just put his own<br>abbreviation. He/she is the developer in this case.<br>In the same time simple users should not be even aware of above issue if they<br>do not want. They most probable wouldn't want that unless they are using SQL
<br>or scripting.<br><br>We _cannot_ assume everyone is simple user nor advanced user. I mentioned<br>about data warehouses. I don't know about your impressions, but in this case I<br>encountered cases when I already have predefined latin1 names in one linked
<br>database (ofter only 8 or 12-character long) and just in my master database I<br>wanted to add descriptive captions that I can then use in GUI and project<br>documentation.<br><br>Another place power users may want to see real names and not captions by
<br>default is project navigator ( on the left hand:<br><a href="http://kexi-project.org/pics/0.9/data_form_navigator.png">http://kexi-project.org/pics/0.9/data_form_navigator.png</a> ) or table/query<br>column names.</blockquote>
<div><br>Just a question. How would an advanced user "communicate" with a
normal user? For example, one user creates a table using captions,
other uses names, or vice-versa? I'd think that to reduce confusion,
BOTH names should be seen all the time, regardless of user status;
though, the capton/name should be put to a side in smaller print or
something. I'm thinking about the case where there are many
tables/queries with simmilar name and an advanced user is talking to a
normal user.
<br> </div><br></div>