>Hello everyone,
>
>I have a buffered cursor that is the source of a SQL query (the result beeing a summary using Group By). Everything works fine except for a small detail: changes in the source cursor aren't "seen" by the SQL query until a TableUpdate is called.
>
>Of course, that's not what I want, since I would like to have the summary display change as I enter/change data in the source cursor.
>
>I could always forget the SQL query and calculate it manually using Scan ... EndScan, but using SQL is so much easier! :-)
>
>VFP5. The source of the first cursor isn't a local table; it's on a SyBase server.

Well, your select is going to the source of the cursor to get the values, not the change buffer. I think this is pretty standard.

sum MyField to TotMyField

since an xBase command should read the buffered values and is fairly simple to use.

BOb