>Erik,
>That's what I thought, too. However, I've just run a (silly) test and to my great surprise the following works correctly in both VFP6 and VFP7
>
>
>CREATE CURSOR test (select C(1), from C(1), where C(1), order C(1), group C(1), having C(1))
>INSERT INTO test VALUES("A","A","A","A","A","A")
>INSERT INTO test VALUES("1","1","1","1","1","1")
>INSERT INTO test VALUES("B","B","B","B","B","B")
>SELECT select, from, where, order, group, having FROM test ORDER BY order
>
>
>Using SQL keywords in a Fox2.x query caused problems.
>
>Please note that I'm *not* advocating to use reserved key words, but thought that it is interesting that the VFP parser is really quite sophisticated and able to handle such stupid queries.
>
Try these:
update test set from = "2"
update test set order = "2"
update test set group = "2"
update test set having = "2"
Erik Moore
Clientelligence