>>>Hi,
>>>
>>>I have a line of code in my program which has a comment dating back to 2002 and refers to a bug in VFP 6.
>>>
>>>Here is the line with the comment:
>>>

>>>*** 11-18-2002 REFACTORING. Calculate QTY In Stock (in INVSTOCK) and update field INVNTORY.INSTOCK 
>>>***                        Note: Using SUM() function instead of SQL Select because of bug in VFP 6.0 
>>>SELECT (cInvenStockView)
>>>SUM QTY_LEFT to nQtyInStock for REC_ID = "1" AND INVEN_PK = tnInvenPk
>>>

>>>
>>>The code above should calculate the sum of field QTY_LEFT. Which could be done by SQL Select from the Cursor Adapter cursor.
>>>
>>>I know I should know why I used SUM instead of SQL Select. But can someone remember what was the bug? And should I now (since the program is in VFP 9) change the above code from SUM to SQL Select?
>>
>>If you were on UT or Foxite in late 2002, have you checked your own messages from around that time?
>
>I don't think I was on UT back then. I think I was using the message board on Compuserve. But I am not sure.

Looking at messages in your user profile, you posted 22 messages in 2002, your first message on this site was November 13, 2002.

From that view you can view your messages, see if any of them are related to this.

The Fox Wiki has a record of an obscure SELECT bug supposedly fixed in VFP7: http://fox.wikis.com/wc.dll?Wiki~VFPUndocumentedBugs~WIN_COM_API . Search that page on "but not arrays".