Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yuri Rubinov
  Where is Yuri Rubinov?
 Philadelphia
 Pennsylvania - United States
 Yuri Rubinov
 To: Oxy-
  Where is Oxy-?
 
 Lithuania
 Oxy-
 Tags
Subject: RE: Remote View -> Modify -> Missing Operand??
Thread ID: 15869 Message ID: 15915 # Views: 1 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Thursday, October 03, 2002 6:23:35 PM         
   


> > I think that only what you need is to redefine the view or index expression for this view.
> what do you mean by that, how can i do this?

Something like this:

open data yourdata
list data to c:\hi.txt
modi file c:\hi.txt
* from this you should see information about view, like

View statview
*UpdateType 1
*WhereType 3
*FetchMemo TRUE
*ShareConnection TRUE
*SendUpdates TRUE
*Prepared FALSE
*CompareMemo TRUE
*FetchAsNeeded FALSE
*UseMemoSize 255
*FetchSize -1
*MaxRecords -1
*Tables coops!sta_mstr
*SQL SELECT * FROM coops!sta_mstr WHERE status ORDER BY station
*SourceType 1
*BatchUpdateCount1
Field station
*KeyField TRUE
etc................................

* So youn can strip out sql statement and all view properties and do this:

CREATE SQL VIEW statview AS ;
SELECT *;
FROM coops!sta_mstr;
WHERE status;
ORDER BY station
?dbSetprop("statview","VIEW", "ShareConnection", .T.)
?dbSetprop("statview","VIEW", "FetchSize", -1)
?dbSetprop("statview.station","FIELD", "KeyField" , .T.)
?dbSetprop("statview.lstsrvdt","FIELD", "Updatable", .T.)
?dbSetprop("statview.lastfaxed","FIELD", "Updatable", .T.)
?dbSetprop("statview","VIEW", "SendUpdates", .T.)




ENTIRE THREAD

Remote View -> Modify -> Missing Operand?? Posted by Oxy- @ 10/2/2002 6:10:31 PM
RE: Remote View -> Modify -> Missing Operand?? Posted by Yuri Rubinov @ 10/3/2002 2:40:54 PM
RE: Remote View -> Modify -> Missing Operand?? Posted by Yuri Rubinov @ 10/3/2002 2:43:31 PM
RE: Remote View -> Modify -> Missing Operand?? Posted by Oxy- @ 10/3/2002 3:00:47 PM
RE: Remote View -> Modify -> Missing Operand?? Posted by Yuri Rubinov @ 10/3/2002 6:23:35 PM