We are using Webfocus 8.1. I was wondering if the actual text of the SQL code written in the developer studio gets written in the repository tables. When I looked around in the WF_REPOSOBJ table it gives the PRT_PATH AS /WFC/Repository/.... for a .fex file. I couldn't locate this file on the server. Any pointers would greatly help us to retrieve the code for a few hundred records rather than clicking through each individual report.

Thank you,
Shashi

This message has been edited. Last edited by: <Emily McAllister>,

The different file types are stored in the table WF_CONTENT_REVS and are stored as an image.

The field BCONTENT contains the content of what ever the file type is.

Waz - thank you ! This helps.

If you are OK with the answer, then please edit your first post and add [SOLVED] or [CLOSED] to the title

Waz,

Congratulations on passing 5000 posts, you'll soon catch Francis!

T

Tony, you're not far behind.

I'm hoping when Francis gets to 10K, he will count down.

quote:

you're not far behind

Yes, but I was ahead until last week

I believe that Francis had an earlier alias, so if you added those posts he would certainly top the 10K count.

T

Actually, I've also got a previous alias, from when I worked for IB. Don't even remember what it is.