>>>>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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham