I’m looking for the thread “Use of Modern Roses XI CD” on the Rose Hybridizers Forum at http://tgpnet.com/brd2000/nb2290/view.pl?board=nb2290. According to the RIRS site, in this thread Henry Kuska and Jim Turner give instructions for correlating the ID numbers in the Modern Roses database and for setting up very useful ancestry queries in a modified version of MRXI.
Are these older threads archived?
Rick
I dug though a program I wrote to extract info from the XI database.
There are 2 different id used to index roses in the database. This is the condition you might be looking for
IDNUM_1 = ((999999 - IDNUM_2) / 2)
Thanks!
The old RHA Forum is available at http://www.rosemania.com/disc3_frm.htm
Thanks, Peter!
This is the MS Access query I use most when researching parentage:
SELECT N.NAME, B.REGYEAR, B.HYBRDZR, B.TYPE, B.COLOR, B.FRAGRANC, P.PARENTS
FROM MR11NAME AS N, MR11BASE AS B, MR11PAR AS P
WHERE 999999 - N.IDNUM * 2 = P.IDNUM AND B.IDNUM = P.IDNUM AND N.BOLD = ‘Y’
ORDER BY N.NAME;
It displays one line for each unique variety whose parents are listed in MR XI. You can use filters and sorts to get more specific info. For example, if you want to see which roses have Ophelia as a seed parent, left click on the Parents column, and enter ‘Ophelia X*’ in the ‘Filter For’ field.
Some roses have multiple names, so it’s a good idea to look at the NAME table to check that. For example, Fragrant Cloud also goes under the name Duftwolke, so to see which roses have Fragrant Cloud as a seed parent, the filter would be ‘Fragrant Cloud X* or Duftwolke X*’
The old links for the first half of the posts on this forum no longer work. Is there a link where they can be found?
Thank you,
Henry Kuska
Sorry, they broke because I ported the forum to new software. The posts themselves are mostly intact but the url’s changed and not in a systematic way so it was not possible to convert links.
The old links for the first half of the posts on this forum no longer work. Is there a link where they can be found?