From: Fabian S. <fab...@we...> - 2005-10-19 20:52:19
|
Hello, I have again a suggestion. Still, my configuration is: pilot-db v.1.1.3 (14Feb 2005) PalmOS v.3.5.3 Palm IIIxe (16 MHz, 2MB ROM + 8MB RAM) If you use a field in a filter (and perhaps even in a script, I haven`t tested this) it seems that this field is stored by its position in the database, not its name. That causes the problem that filters (and,as said above perhaps even scripts) often do unwanted things after changing the database layout. An example: You have a database with the structure: first_name last_name adress email friend Now you create a filter with which only the records are showed where "friends" is set to "TRUE". No, because you notice that this is better, you replace the field "adress" by the fields "street_number", "zip", "city", "state" and "country". If you rebuild the database, view it and select the "friend"-filter created above you get no results displayed. If you have a look at the filter you see that thefield "city" is selected instead of the field "friends". That seems to be because the position of the field "friend" in the database was stored when creating the filter, not its name. And now, after the change in the structure of the database, the field "city" is at this position. I know that a database should be layouted in a way that the layout only has to be changed as few as possible. But I think like it is now it is hard work to edit all filters and scripts to do what they sshould do after changing the database`s structure. A possible solution could be to adress the fileds by their name instead of their position in the db. Then something should be added to avoid the creation of a db with more that one field having the same name (what is possible at the moment). Preverably an error message that returns you to the layout editing window _without_ resetting the values you entered before. Again: I`m not too good in English and it`s late - could you understand what I wrote? Greetings ______________________________________________________________ Verschicken Sie romantische, coole und witzige Bilder per SMS! Jetzt bei WEB.DE FreeMail: http://f.web.de/?mc=021193 |