Archives of Rose Hybridizers Forum?

Post a reply


In an effort to prevent automatic submissions, we require that you complete the following challenge.

BBCode is ON
[img] is ON
[flash] is OFF
[url] is ON
Smilies are OFF

Topic review
   

If you wish to attach one or more files enter the details below.

Expand view Topic review: Archives of Rose Hybridizers Forum?

Re: Archives of Rose Hybridizers Forum?

by 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?

Re: Archives of Rose Hybridizers Forum?

by 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

Re: Archives of Rose Hybridizers Forum?

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

Re: Archives of Rose Hybridizers Forum?

by Rick » Fri Apr 02, 2004 1:00 am

Thanks, Peter!

Re: Archives of Rose Hybridizers Forum?

by Peter Harris » Fri Apr 02, 2004 1:00 am

Re: Archives of Rose Hybridizers Forum?

by Rick » Fri Apr 02, 2004 1:00 am

Thanks!

Re: Archives of Rose Hybridizers Forum?

by 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)

Archives of Rose Hybridizers Forum?

by 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

Top