Has anyone ran into problems with SQL failing for no apparent reason? I've got an SQL:
select &vfield1 as f1, Due as f2, Assignedto as f3, * ;
from Test2;
order by f1, f2, f3 into cursor printout

that will fail depending on what I've put in Vfield1. I can't figure it out. The only things I'm putting into Vfield1 is valid column names. Test2 is also a cursor, but it works 60 % of the time. I am really frustrated. This is also an app that was upgraded from 2.5 to 5.0a, if that matters any. Any advice would be appreciated. Thanks!

Laurisa Watkins
Seattle Parks