>>Good morning,
>>
>>As I am refactoring some old code that was initially written in VFP6, I came across the following note above code:
>>
>>*** Use SUM() function instead of SQL Select because of bug in VFP *** 6.0
>>SELECT MYTABLE
>>SUM QTY_LEFT to nQtyInStock for REC_ID + INV_CODE = "1" + cInvCode
>>
>>
>>Anybody remember what this bug was about and if I can change it now safely to SQL Select? Or was it from the fact that SQL Select would look into the buffered view of the table instead of the table on the disk?
>
>I think you meant that Select-SQL works with the table on the disk (and not buffered). I don't remember any bugs here.
Thank you. I guess since SUM works I should not touch this code and leave it as is.
"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