I don't think you can update more than one table from a view, but that wasn't why I wanted a list of tables. What I wanted to do was copy the field captions from the tables to the corresponding view fields without having to do it in the view designer. I've got round it by writing a function to extract the table names from the SQL.
Laurie On 26 September 2014 11:03, Thierry Nivelet <[email protected]> wrote: > Should match the > DBSETPROP("somelocalview","VIEW","Tables", ...) > that you have in the view definition code > > if you use the view designer, you need to select 'display SQL' to view > this code > > never updated several tables with a single view. > > Thierry Nivelet > FoxinCloud > Give your VFP app a new life in the cloud > http://foxincloud.com/ > > Le 25 sept. 2014 à 13:00, Laurie Alvey a écrit : > > > When I issue ? DBGETPROP("somelocalview","VIEW","Tables") it only ever > > shows one table even when the view has 3 or 4 tables in its definition. > The > > VFP Help file says the function returns a comma delimited list.. The > tables > > are linked using the JOIN syntax and I wonder if this is confusing the > Fox. > > > > Laurie > > > > > > --- StripMime Report -- processed MIME parts --- > > multipart/alternative > > text/plain (text body -- kept) > > text/html > > --- > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAMvTR9eb7=wz4gfqrmwnxuf12yk4zl7hfaramybotx9oekb...@mail.gmail.com ** 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.
