List of Objects / Members of myPJX file 1

[Koen Piller]

Hi,

Do we have a procedure which will list all the files in myProject, preferably grouped by:
1. DataBases

Free Tables​

Queries​

2 Documents

Forms​

Report​

Labels​

a.s.o.

like Tabpages in the PJX

Stay healthy,
Koen

 

[Gerrit Broekhuis]

Hi Koen,

You could open the pjx file as a table (use mypjx.pjx) and create a procedure with the information in these records.
It’s a bit of work, but probably doable.

I don’t have a ready-to-go procedure unfortunately.

Regards, Gerrit

 

[Koen Piller]

Gerrit,
Yes that's the way I would do it also, however as you say, it is a bit of work. The members are listed in the memofield but certainly not 'ready to use to make a list'
Stay healthy,
Koen

 

[Mike Lewis]

Koen,

You might try exploring some of the options in the Documenting wizard (Tools -> Wizards -> Documenting).

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Koen Piller]

Mike
It seems to me I am not so handy with that wizard: I get 2 empty tables plus a cdx file.
stay healthy,
Koen

 

[Chris Miller]

There is _VFP.ActiveProject.Files and each File object has a FileType for categorization.
Using the PJX as a table has one advantage: You don't need to open the project in VFP to query it.



Chriss

 

[TamarGranor]

Seems to me you could do a query of the PJX that would sort the files as you want them.

Tamar

 

[Mike Lewis]

Following Chris's suggestions, you could do something like this:

MODIFY PROJECT "MyProject" NOWAIT 
loProj = _VFP.ActiveProject
FOR EACH loFile IN loProj.Files
  ? loFile.Name, loFile.Type
ENDFOR

Obviously, this can be refined to produce something more useful, but it should provide a start.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Koen Piller]

Mike,
Again one of splendid ideas!
Will construct and publish here for those interested.
Stay healthy,
Koen

 

[tomk3]

Hi,

sorry for writing so late, but what about PDM ?

http://gorila.netlab.cz/pdm.html

Regards
tom