Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to define such view?
Message
 
 
To
01/03/2005 13:31:17
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
00991616
Message ID:
00991700
Views:
18
This works:
SELECT Saved_Searches.* ;
  FROM mmviscollect!saved_searches ;
 WHERE Saved_searches.cusgrlink_fk == ( ?vp_cusgrlink_fk );
 OR (Saved_searches.cusgrlink_fk == ( ?vp_vcam_fk ) ;
    AND NOT EXISTS(SELECT * FROM mmviscollect!saved_searches ;
                   WHERE Saved_searches.cusgrlink_fk == ( ?vp_cusgrlink_fk )));
  ORDER BY Saved_searches.isequence_number
Your first query produced an error message "QUERY of this sort is not supported" (I'm running 8.0)

>>Hi everybody,
>>
>>I have a problem to which I don't see an immediate solution, so I am hoping that great minds from UT can help me with it.
>>
>>I have a view
>>CREATE SQL VIEW LV_SAVED_SEARCHES AS ;
>>SELECT Saved_searches.* ;
>>	FROM mmviscollect!saved_searches ;
>>	WHERE Saved_searches.cusgrlink_fk = ( ?vp_cusgrlink_fk ) ;
>>		OR Saved_searches.cusgrlink_fk = ( ?vp_vcam_fk ) ;
>>	ORDER BY Saved_searches.isequence_number
>>
>>Now, in its current way it will always return all records, because we defined all of them for VCAM user. I want it to return "my" records if it finds that cUsgrLink_fk matches my cUsgrLink_fk. However, if I don't have records for my ID, I want it to return all records. Could you please help me a little bit?
>>
>>Thanks in advance.
>
>Add a line:
>
>CREATE SQL VIEW LV_SAVED_SEARCHES AS ;
>SELECT Saved_Searches.* ;
>  FROM mmviscollect!saved_searches ;
> WHERE Saved_searches.cusgrlink_fk = ( ?vp_cusgrlink_fk );
> OR Saved_searches.cusgrlink_fk = ( ?vp_vcam_fk ) ;
>    AND ?vp_cusgrlink_fk NOT IN (SELECT * FROM mmviscollect!saved_searches);
>  ORDER BY Saved_searches.isequence_number
>
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform