Page 1 of 1
Only List Active Aquaria when Adding to My Cats
Posted: 19 Oct 2011, 15:59
by Martin S
When you add (a nd subsequently edit) a new addition to My Cats, it gives you the option to assign the fish to an aquarium - could this list only show those that are active?
I'm assuming it's something along the lines of 'AND [MY_Aquaria].[Stop_Date] IS NULL' type addition to the query that brings back this list?
Martin
Re: Only List Active Aquaria when Adding to My Cats
Posted: 19 Oct 2011, 16:05
by MatsP
I'm moving this to "Bugs", as it's clearly wrong. And I agree, it's conceptually the fix you describe. It's slightly more complicated because the code for "take things from a database and make it into a drop-down" is generic (it's used to select species, genus, etc, etc), but I think there is a way to add an extra statement.
--
Mats
Re: Only List Active Aquaria when Adding to My Cats
Posted: 21 Oct 2011, 08:26
by MatsP
Fixed in R548.
--
Mats
Re: Only List Active Aquaria when Adding to My Cats
Posted: 22 Oct 2011, 21:09
by Jools
MatsP wrote:Fixed in R548.
--
Mats
Uploaded. Fixed?
Jools
Re: Only List Active Aquaria when Adding to My Cats
Posted: 24 Oct 2011, 14:27
by Martin S
Looks good to me - thanks
Sorry, can't test it via tapatalk and don't turn on the PC much when not at work ;)
Thanks again
Martin