Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP 5.0a SQL Substitution Problems (bug?)
Message
From
09/04/1998 17:43:54
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
VFP 5.0a SQL Substitution Problems (bug?)
Miscellaneous
Thread ID:
00090941
Message ID:
00090941
Views:
72
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
Map
View

Click here to load this message in the networking platform