>>>>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".

Thank you, Al.