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
|
