On Wed, August 13, 2008 2:07 pm, Stephen Russell wrote: > On Wed, Aug 13, 2008 at 8:56 AM, John J. Mihaljevic > <[EMAIL PROTECTED]> wrote: > >> Hi all, >> >> >> We've got an app running off-site. Whenever I make changes to the >> structure of tables on my end, I've been writing little programs using >> commands such as ALTER TABLE to make the changes to the structure of the >> tables on the user's end. >> >> But what if I make changes to a view? How do I transfer those changes >> to the user's site? > > --------------------------------------- > > > drop view viewName > > create view YourSyntaxHere > > go
I thought you meant a VFP (remote or local) view? If you're doing ALTER TABLES on VFP databases offsite, you're in serious need of SDT (Stonefield Database Toolkit). I ship my views database with my EXE (they both reside on the client). _______________________________________________ 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.
