Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Frustating with view designer...
Message
From
02/11/1999 08:21:17
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00285299
Message ID:
00285372
Views:
14
>thanks, Cetin, but the "users" that we are talking about maybe other programmers in our team...


That's why I don't work with a team :) Kidding.
Then you should create "view designer proof" views. One way is to change the sql to something that designer would complain it's too complex and wouldn'topen at all :
CREATE SQL VIEW "MYVIEW" ; 
   AS SELECT a.*   ;
   FROM mydata a  ;
   WHERE a.f1 = ?m.V1  ;
     AND a.f2 = ?m.V2  ;
     AND a.f5 = ?m.V5  ;
     AND a.f6 = ?m.V6  ;
     AND a.pk in ;
     (select pk from mydata b where b.f3 = ?m.V3 or b.f4 = ?m.V4)
Only shortcoming is that you cannot set update criteria and other properties visually (nonvisual view). You have to code all of them. That's not a big concern though.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform