I have been reading the manual section on "smart fields" and am trying to understand it. www.sqlnotes.net/drupal5/index.php
It seems that you create a "smart field" the same way that you create a regular field, except you enter text like the following in the Options field for the smart field (in this case, a Text field named "Year"):
It seems that you create a "smart field" the same way that you create a regular field, except you enter text like the following in the Options field for the smart field (in this case, a Text field named "Year"):
Now here is what I am GUESSING is going on here -
The SELECT statement generates a table from which acts as the <source> from which the value of the "smart field" "Year" is drawn. This source table appears to have 2 fields - ItemID, and Year. IQ looks in this generated table to find an item's ItemID number, and assigns the value in the Year column in that row as the value of the Year smart field for that item.
Now ItemID and Date appear to two fields in table called "¯qDate". ?? I've never seen that "overline" character in front of the "q" before, but I see that it's HEX AF in the ASCII table, and is called the "spacing macron" or "overline". I don't know if that character and the q have a special meaning in SQL, or whether that is just Pierre's choice for designating a Date table in the database.
Do I have this right? Clarifications or corrections?
Comments
"The overscore was to group DB related stuff away from the rest (i.e. grids). That way, grids are shown first and are therefore easier to choose (when linking with Office apps).
I also wanted to have a character which is very rarely used to ensure that users wouldn't create fields with that character."
(Note that the old 2009 file didn't migrate gracefully, though all the data is there. I'll finish cleaning it up, and post a 2018 update. It has a lot of info that didn't make it into the manual)