>>>Hi All
>>>
>>>Forgive my lack of formatting, every time I want to format code on the UT, I can never find any document listing the tags.
>>>
>>
>>hit reply to see the tags i've used for this response.
>>
>>>SELECT Products.*,Prices.Price ;
>>>FROM Products
>>>inner join Prices on Products.ID = Prices.ID ;
>>
>>change up this part of the query a bit (assuming numeric id field)
>>
>>>and Prices.ID in ;
>>>(SELECT Prices.ID,MAX(prices.effective_date) FROM Prices ;
>>>group by Prices.ID )
>>>
>>
>>to
and transform(prices.id)+dtos(prices.effective_date) in ;
>> (select transform(prices.id)+dtos(max(prices.effective_date)) ;
>> from prices group by prices.id)
and see if that works for you.
>
>note: this was done in VFP 6 SP3 - so 7 should be able to do this
Yet another - I have been Transform() happy today: Make it STR() instead of Transform()
Insanity: Doing the same thing over and over and expecting different results.