Laurisa,

What is the error message?

What is an example of one that works and one that does not?

I've seen errors with ORDER BY clauses that go away when relative field numbers are used instead of field names (in this case: 1, 2, 3 INTO. . .). Worth a shot.

Good Luck,
Jim N

>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