Hi Laurie:
I've tested it, and your DBGETPROP returns all tables for me.
I've made a new database (NW.DBC) and a local view (orders_by_customer)
using Northwind orders and customers tables from Samples directory,
selecting 3 fields of each table, then:
*1) Get tables from the view:*
? DBGETPROP("orders_by_customer","VIEW","Tables")
NORTHWIND!ORDERS,NORTHWIND!CUSTOMERS
*2) Use the DBC as a table to get more info not available with DBGETPROP:*
USE NW.dbc ALIAS bdd SHARED AGAIN NOUPDATE
*3) Select the fields of the defined query:*
SELECT bdd1.Objectname FROM bdd bdd1 ;
INNER JOIN bdd bdd2 ON bdd1.parentid = bdd2.Objectid ;
WHERE bdd2.Objecttype = "View" AND bdd2.Objectname =
"orders_by_customer"
Query-----------------------------------------
contactname
address
shippostalcode
companyname
shipname
shipcity
So now you can use this fieldnames with DGETPROP to get more info about
each one.
Hope it helps,
Best Regards.-
2014-09-25 13:00 GMT+02:00 Laurie Alvey <[email protected]>:
> 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/CAGQ_Juntd6wHkY3+CBxcUsrZc=tvG901dJMpjMaq=ihuhua...@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.
