variable table name

exor,

Two things:
1. HOLD file names for use with !IBI.FIL are limited to 8 characters
2. Shouldn't you have HOLD FORMAT HTMTABLE?

Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006

Ignored post by Danny-SRL posted

Member

posted

it's 3 days that I'm working around this....
and the solution was 8 character

now that i remember it's the second time that this problem joke on me
i hope that it's caused by the warm temperature here

sigh

thank you thank you thank you

last question, the last version of WebFocus expand this limit of 8 characters table?

thank you again

This message has been edited. Last edited by: ExoR,

WebFOCUS Version 8.2.0.1
Windows Server 2012

WebFOCUS Version 5.3.3
Windows 2000
Oracle 8i

Posts: 15 | Registered: June 23, 2008

Ignored post by ExoR posted

Danny-SRL

Virtuoso

posted

ExoR,

No. I have 7.6.5 and it is still 8 chars.
Better luck next time!

Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006

Ignored post by Danny-SRL posted

Waz

Expert

posted

ExoR, If you change &IBI_FIL to being on a line by its self, it will help.

-* &USERID is passed by a form
-SET &USERID='ITALY';
-SET &TABUSERID = 'U_' || &USERID;

-SET &IBI_FIL = '!IBI.FIL.' || &TABUSERID || ';';

TABLE FILE CAR
PRINT COUNTRY
BY COUNTRY NOPRINT
IF COUNTRY EQ &USERID
ON TABLE HOLD AS &TABUSERID
END

-RUN
-HTMLFORM BEGIN
<html>
<head>
<title>Title</title>
</head>
<body>
-* <!--WEBFOCUS TABLE '&TABUSERID'>
-* !IBI.FIL.&TABUSERID;
Welcome <br> 
&IBI_FIL
</body>
</html>

-HTMLFORM END
-RUN
-EXIT

Also, the question arises, why do you want to create a long name, these files are temporary, unless you are keeping them, why have unique long names ?

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006

Ignored post by Waz posted

Member

posted

This fex I've wrote over here is only a simple example, now I have to use this knowhow with other procedure that are more complex, and some of them take long time to end. If one user execute a procedure and take long time to produce a temporary table named "Example.ftm", and in the meanwhile another user execute the same procedure, I think there will be some problems. Otherwise if the procedure can produce an "Example_&UserID.ftm", both users can execute the fex without problems.

I think and hope there is a solution to create a session for every user logged in, but unfortunately i'm not paid for programming on webfocus, and the 80% of my work consist in other things, so i don't have the whole 8 working ours to spend on it

so i have to choose the straight way. If it's not clean and it's not perfect but it works, i've to choose this way, and next time if i have free time to spend on it, i can try to do a better application.

WebFOCUS Version 8.2.0.1
Windows Server 2012

WebFOCUS Version 5.3.3
Windows 2000
Oracle 8i

Posts: 15 | Registered: June 23, 2008

Ignored post by ExoR posted

Danny-SRL

Virtuoso

posted

ExoR,

There are many ways to create a random name. But is that what you need?

For instance you can use &FOCCPU which gives you the number of milliseconds of used cpu time since your WebFocus server started.

Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006

Ignored post by Danny-SRL posted

GCohen

Platinum Member

posted

The HTMLFORM technique is quite old and has an 8 character name limit. But if you create the FORM in the Layout painter and reference the report, then you can name the report as long as you like, and can concatenate USERID, DATE, etc into the name.

Release 7.6.9
Windows
HTML

Posts: 226 | Registered: June 08, 2003

Ignored post by GCohen posted

Waz

Expert

posted

ExoR, are you aware that when a fex is run a separate temporary directory is created, all files are for each session are in these directories (Unless otherwise coded).

I don't see that there will be any clash.

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006

Ignored post by Waz posted

Member

posted

to Danny-SRL:
no I don't need random name for table, but &FOCCPU is an interesting tip that i will remember

to GeraldCohen: i don't understand what you mean, why if i create a form manually and reference the report with a table name longer than 8 character doesn't work, and if i do the same in Layout painter it works?

to Waz:
no, what you say doesn't happen in my case. I'm not the one who set up the server for webfocus, and the 2 technician that have done it are gone away years ago...
actually there is no login request and no session for every user, but there is one session with one temporary directory for every coder.
If i could i would like to do a "format c:" and start up with a clean server... but i can't...

-----------------------------------------------------------

Now i'm trying another way

 
-SET &DIR1='ADS_FOCEXEC_' || &PRGUSER;
-SET &TEMP='ADS_TEMP_' || &PRGUSER|| '\' || &USERID;
-SET &CTEMP= 'f:\ibi\apps\' || &TEMP
! md &CTEMP

APP PATH &DIR1 ADS_ENVIR_CONFIG ADS_FOCUS_DATA ADS_FOCEXEC_METEO &TEMP
APP HOLD &TEMP
APP HOLDMETA &TEMP
APP HOLDDATA &TEMP

-SET &TABUSERID = 'TABUSER_' || &USERID;

-SET &IBI_FIL = '!IBI.FIL.' || &TABUSERID || ';';

TABLE FILE ADB_USER
PRINT NAME SURNAME
BY USERCODE NOPRINT
IF USERCODE EQ &USERID
ON TABLE HOLD AS &TABUSERID
END

-RUN
-HTMLFORM BEGIN
<html>
<head>
<title>Title</title>
</head>
<body>
Welcome <br> !IBI.FIL.&TABUSERID;
</body>
</html>

-HTMLFORM END
-RUN
-EXIT

&PRGUSER is the ID of the coder (me in this case)
so every coder has his own temporary directory, and every fex executed by a coder produce temporary file in a proper directory,
but the other 2 coder doesn't have an intranet site, they produce fex and run by themselves
i've added the &USERID that is the login took with asp Request.ServerVariables("LOGON_USER") and passed to webfocus

it will become
-SET &DIR1='ADS_FOCEXEC_EXOR'
-SET &TEMP='ADS_TEMP_EXOR\ID3123'
-SET &CTEMP= 'f:\ibi\apps\ADS_TEMP_EXOR\ID3123'
! md &CTEMP

APP PATH &DIR1 ADS_ENVIR_CONFIG ADS_FOCUS_DATA ADS_FOCEXEC_METEO &TEMP
APP HOLD &TEMP
APP HOLDMETA &TEMP
APP HOLDDATA &TEMP

but when i try to hold a file (ON TABLE HOLD AS &TABUSERID), i don't find it anywhere...
the directory f:\ibi\apps\ADS_TEMP_EXOR\ID3123 exists, but it's empty.
I've searched all the *.ftm file in f: created less than 1 hour ago, and I've found nothing.

the oddest thing is that the output of this procedure is correct, i can see correct response:
Welcome
Name Surname <-ibi filled table

so... i'm still working on it

This message has been edited. Last edited by: ExoR,

WebFOCUS Version 8.2.0.1
Windows Server 2012

WebFOCUS Version 5.3.3
Windows 2000
Oracle 8i

Posts: 15 | Registered: June 23, 2008

Ignored post by ExoR posted

Member

posted

I'm beginning to ate filename length restriction of web focus...
I can't associate to &TEMP a tree of directory that has a length greater then 18 characters
I can create a Temporary directory tree like this made by 18 characters:
-SET &TEMP='1\3\5\7\9\1\3\5\7\';
But if I try this made by 19 characters and less subfolder
-SET &TEMP='1\3\5\7\9\1\3\56789';
doesn't work

WebFOCUS Version 8.2.0.1
Windows Server 2012

WebFOCUS Version 5.3.3
Windows 2000
Oracle 8i

Posts: 15 | Registered: June 23, 2008

Ignored post by ExoR posted