Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View Definition has changed.
Message
From
17/04/2003 14:01:30
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
View Definition has changed.
Miscellaneous
Thread ID:
00778975
Message ID:
00778975
Views:
55
I'm fairly sure this one has come up before, but I can't find it.

When attempting to requery a view, I get Error 1494 - View definition has changed.
SELECT Leads.leadid, Leads.leadname, Leads.phone, Leads.admissrepid,;
  Leads.resolution,;
  IIF(ISNULL(Enroll.enrollid),0,Enroll.enrollid) AS enrollid,;
  IIF(ISNULL(Lookuplist.entry),SPACE(20),Lookuplist.entry) AS entry;
 FROM ;
     smagic!leads ;
    LEFT OUTER JOIN smagic!enroll ;
   ON  Leads.leadid = Enroll.leadid ;
    LEFT OUTER JOIN smagic!lookuplist ;
   ON  Leads.resolution = Lookuplist.lookupid;
 WHERE  UPPER(Leads.leadname) = UPPER(?vp_leadname);
   AND  Leads.phone = ( ?vp_phone )
Both parameters are character. All values for vp_phone work correctly. When vp_leadname is given a value that would return only one record, it throws the error. A blank vp_leadname or one that returns several records works properly.

Nothing in the code is changing the view. I have deleted and recreated the view, packed and compiled the database, and the error persists. I'm using VFP 8 and Mere Mortals 7.1.
Next
Reply
Map
View

Click here to load this message in the networking platform