Archives of Rose Hybridizers Forum?

A meeting place for rose breeders.
Rick

Archives of Rose Hybridizers Forum?

Post: # 3658Post Rick
Thu Apr 01, 2004 1:00 am

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

StevenJ

Re: Archives of Rose Hybridizers Forum?

Post: # 3659Post StevenJ
Thu Apr 01, 2004 1:00 am

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)



Peter Harris
Posts: 1003
Joined: Thu Oct 13, 2011 1:08 am
Location: Charleston, West Virginia
Contact:

Re: Archives of Rose Hybridizers Forum?

Post: # 3663Post Peter Harris
Fri Apr 02, 2004 1:00 am

Peter
Charleston, West Virginia
USDA Hardiness zones 6A-8A, depending on the year


Jim Turner

Re: Archives of Rose Hybridizers Forum?

Post: # 3668Post Jim Turner
Fri Apr 02, 2004 1:00 am

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*'

henry kuska
Posts: 783
Joined: Thu Dec 15, 2011 9:06 pm
Contact:

Re: Archives of Rose Hybridizers Forum?

Post: # 67307Post henry kuska
Mon Mar 12, 2018 11:00 pm

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

Don
Posts: 1747
Joined: Wed Dec 31, 1969 7:00 pm
Contact:

Re: Archives of Rose Hybridizers Forum?

Post: # 67414Post Don
Sun Mar 25, 2018 1:15 pm

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?
What doesn't kill them makes them stronger.

Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests