Rick Schummer wrote: >>> But what if I make changes to a view? How do I transfer those changes to > the user's site?<< > > You can script out a CREATE SQL VIEW command just like you do the ALTER TABLE. You can use the View > Designer to show code and grab this for your program, or GenDbc to script out the entire database > (just grab the code from the function for the view), or maintain your views in a program and send it > as needed. If all sites are using the same exact database you can send the DBC files, but this could > be a problem if the DBC is copied in and one of your table structure update programs are not run. > > Personally, if it was my choice I would go get the Stonefield Database Toolkit. All your structures > are stored in metadata. It has the functionality where you ship the metadata, the DBC files and call > an Update method. Magically all your structures are updated (as are your views stored in the DBC). > Even works for free tables too. No need to keep track of every stinking change you make to the > database. > > Rick > White Light Computing, Inc. > > www.whitelightcomputing.com > www.swfox.net > www.rickschummer.com
I'll add to that that I maintain my local views with Rick's ViewEditor tool. If I had to use the native view editor, I'd have quit Foxpro long ago. Rick's tool really is worth much more than he prices it for, and I get no commission so that's an honest perspective! _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
