Just in case this helps someone else down the road, I got one of those
query too complex errors, when trying to delete a record. Also
happened when I tried to update it as well, just as a test. Strange
because I was able to open the dataset, and read individual records
(and field information) just fine.
Anyhow, changing the cursor location property from useclient to
useserver fixed it just fine.
FYI,
-Jerry Irons