Using Named Colors from Asset Catalogue in Ibdesignable Views Crashes Ib Even When Specifying the Bundle

Using named colors from asset catalogue in IBDesignable Views crashes IB even when specifying the Bundle

Turns out it was just Xcode playing up. Cleaning the build folder, derived data and restarting Xcode fixed the issue (when specifying the correct bundle as shown in my code snippet).

Find two consecutive rows

Assuming the rows have sequential IDs, something like this may be what you're looking for:

select top 1 * 
from 
Bills b1
inner join Bills b2 on b1.id = b2.id - 1
where
b1.IsEstimate = 1 and b2.IsEstimate = 1
order by
b1.BillDate desc

Related Topics