General information
Category:
Coding, syntax & commands
Title:
VFP 5.0a SQL Substitution Problems (bug?)
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only