>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.
If it's not broken, fix it until it is.
My Blog