Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why this view doesn't work?
Message
From
02/06/2007 20:12:12
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Why this view doesn't work?
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01229983
Message ID:
01229983
Views:
54
I have defined a view thus
CREATE SQL VIEW "V_INVENTARIO";
AS SELECT * FROM datos!inventario WHERE &?cWhere
But when I run this code I get nothing
use v_inventario in 0 nodata
 selec v_inventario
 cWhere="v_inventario.id>=1"
 selec v_inventario
 requery()
 browse
I know the definition of view is not too "orthodox", but according to what I've read it should work.

What am I missing?

Thanks in advance
Next
Reply
Map
View

Click here to load this message in the networking platform