>Gregory
>
>Thanks for your help, my code now looks like:
>
>sele a.RegionID, b.RegionName from lvRequirementBooking1RequirementList1 a ;
> join lvRequirementBooking1RequirementRegionMaster1 b on (a.RegionID = b.RegionID) ;
> where .T. group by a.RegionID order by b.RegionName into cursor lvRequirementBooking1RequirementFilterRegion1
>
>This gives me a list of all Regions that appear in my lvRequirementBooking1RequirementList1 table. If I wanted to add a record called "All Regions" to the cursor lvRequirementBooking1RequirementFilterRegion1, how would I go about that?
>
>Regards
select a.RegionID, b.RegionName from lvRequirementBooking1RequirementList1 a ;
join lvRequirementBooking1RequirementRegionMaster1 b on (a.RegionID = b.RegionID) ;
where .T. group by a.RegionID order by b.RegionName
union all
select distinct cast(0 as I) as RegionID, 'All Regions' as RegionName ;
from lvRequirementBooking1RequirementList1
where RegionID = 'Some Existing Region'
into cursor lvRequirementBooking1RequirementFilterRegion1
Alternatively create this cursor with ReadWrite clause and add this new item by inserting it.
If it's not broken, fix it until it is.
My Blog