Submitted by Armando on 2009/01/31 18:44
Between versions, some field names change, are added, etc. My database now contains a number of fields that are "obsolete" (not used anymore in the newer IQ version -- thinking of formulas, etc.).
 
e.g. : the due field and duedate field case.... The due field has basically disappeared...  So what happened is that I have a number of items with stuff in duedate, others in due, etc. What a mess. And that's for one field only.
 
It's tedious to have to compare all of these changes from version to version.
 
Could the user be provided with a list of all these modifications between versions so that one can make the appropriate changes at an appropriate time ?
 
thanks.

Comments

To those with the due/duedate problem. (I don't remember which other field has been changed in the last 6 months... sorry)
 
I changed the due field properties to
 
readonly : on
equation: = duedate
 
 
That should do it, in the mean time (if your urgency formula depends on the due field, for instance...)

[quote=Armando]
It's tedious to have to compare all of these changes from version to version.
[/quote]
 
do you then transfer the changes or what -
or do you keep creating new databases ?  [and move stuff from one to the other?]
 
I'm still using fields from when I first started out using SQLN - I can see the advantage of checking, but if you're using due instead of duedate why change (if you do ...) ?
But I'm still only using one db (after experimenting with having more I went back to one)

Armando

2009/02/01 15:14

Permalink

In some cases I've transferred data from one field to the other. Creating another database would be extremely time consuming.
 
The problem with the due/duedate field, for example, is that it's the duedate field that's used when entering data through the add item window... So using a grid with due as a source won't work. Also, the urgency formula in my database still uses the due field, not the duedate one. Maybe all these things don't have too much importance, but they tend to slow me down quite a bit as I have to stop my workflow and check what's happening under the hood...