It may be a good idea to avoid VFP and SQL Server reserved keywords such as Order. Use OrderNmbr or OrderID instead.
>I am so rusty with VFP I have to re learn everything when the boss gives me a project.
>
>Here is my issue, should be simple for you guys.
>
>I have a cursor that consists of data records similar to this
>
>Fields; Order, Item, quantity, unitprice, extendedprice (qty * unitprice)
>
>each order may have multiple items
>
>I want to create a crusor that has each unique order with a total
>
>If I do a SELECT SUM(extendeprice) it gives me the sum of all orders.
>I only want the sum of the extended price for each order.
>
>since I only have one cursor involved, am I correct in using SQL statements.
>
>data example shown as a snapshot jpg image.
>
>I want to create a cursor with each individual order as a record with the sum price of all items on that order.
>
>Sorry for asking something so basic, but I am really out of touch with vfp lately.
>
>steve
If it's not broken, fix it until it is.
My Blog