Yes I did but I only get one table if the field list only contains one table. I think it;s because my version of VFP (7423) is different to yours.
Laurie On 4 October 2014 09:36, Fernando D. Bozzo <[email protected]> wrote: > The 3 DBGETPROPS() I've posted earlier have more than one table. Didn't you > copy/pasted them to compare results? > > > > On 4 October 2014 09:54, Laurie Alvey <[email protected]> wrote: > > > It seems that when there is only one table referenced in the fields list, > > only that table appears in the tables list. Adding a field from a JOINED > > table produces a table list including the new added alias. I don't want > to > > have more fields than necessary in the output - this is a pain. I'll > build > > a list of tables from the SQL by looking at what's in the FROM and JOIN > > clauses. > > > > Laurie > > > > On 4 October 2014 08:30, Laurie Alvey <[email protected]> wrote: > > > > > Interesting. I issued this in the command window: > > > DBSETPROP("residents_v","VIEW","Tables","members!members,members!hons") > > > MODIFY VIEW > > > shows DBSETPROP("residents_v","VIEW","Tables","members!members") but > > > DBGETPROP() returns the correct results. > > > > > > Laurie > > > > > > > > > On 4 October 2014 08:17, Laurie Alvey <[email protected]> wrote: > > > > > >> Thanks. I followed the procedure above bu unfortunately no change. > > >> Laurie > > >> > > >> On 3 October 2014 13:23, Fernando D. Bozzo <[email protected]> wrote: > > >> > > >>> Hi Laurie: > > >>> > > >>> Nexts steps are just for testing if doing what I've done, can resolve > > >>> your > > >>> problem. > > >>> The idea is to regenerate the DBC as I've done, and see if this fixes > > it. > > >>> > > >>> 1) Zip your DBC/DCX/DCT so you have a copy > > >>> > > >>> 2) Delete your DBC/DCT/DCT (the files that compose de DBC databases) > > >>> > > >>> 3) On your data directory (where DBFs and DBCs are), create a text > file > > >>> named *foxbin2prg.cfg* with this inside: > > >>> > > >>> DBF_Conversion_Support: 2 > > >>> > > >>> 4) Right-click your .*DC2* files (is the text version of your DBC) > one > > by > > >>> one, and "Send To / FoxBin2Prg". *This will recreate your DBCs* (1 > saw > > >>> just > > >>> one DBC) > > >>> > > >>> 5) Test the DBGETPROP() I posted earlier, to see if something changed > > and > > >>> if now you can see the correct output > > >>> > > >>> 6) Back here and share the results :) > > >>> > > >>> > > >>> Regards.- > > >>> > > >>> > > >>> On 3 October 2014 12:48, Laurie Alvey <[email protected]> wrote: > > >>> > > >>> > The problem seems to be in the view designer. This line should be > > (for > > >>> > example): > > >>> > DBSetProp(ThisView,"View","Tables","members!members,members!hons") > > but > > >>> in > > >>> > fact is: > > >>> > DBSetProp(ThisView,"View","Tables","members!members") > > >>> > Manually changing it and saving the view makes no difference - it > > >>> always > > >>> > goes back to the incorrect version. Nothing I can do it seems. > > >>> > > > >>> > Laurie > > >>> > > > >>> > On 3 October 2014 10:13, Laurie Alvey <[email protected]> wrote: > > >>> > > > >>> > > Yes, one of the hot fixes (3, I think) changed the version to > 7423. > > >>> > > > > >>> > > Laurie > > >>> > > > > >>> > > On 3 October 2014 10:04, Allen <[email protected]> > wrote: > > >>> > > > > >>> > >> There are 3 hot fixes as well as the SP2. I think hotfix 3 is a > > >>> > >> combination > > >>> > >> as they all replace the exe etc. > > >>> > >> Al > > >>> > >> > > >>> > >> -----Original Message----- > > >>> > >> > > >>> > >> I think that might be the problem. My version of VFP 9 (SP2) is > > >>> > >> 09.00.0000.7423. > > >>> > >> > > >>> > >> > > >>> > >> --- > > >>> > >> This email is free from viruses and malware because avast! > > Antivirus > > >>> > >> protection is active. > > >>> > >> http://www.avast.com > > >>> > >> > > >>> > >> [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/CAMvTR9fpgCkZf=1mk4ygmzmwyxpwq+_ap9va-mbzesrqx8t...@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.
