Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by rummage

  1. rummage

    Delimiter issue

    Hi, I am trying to read a text file. The textfile has a delimiter character '|'. I created the .MAS file like the following FILE=FLATFILE2, SUFFIX=DFIX, REMARK='First Flat File', DATASET='c:\FlatFileData.txt' SEGNAME=ROOT_SEG, SEGTYPE=S1, $ FIELD=ColumnName1, ALIAS=ColumnName1...
  2. rummage

    Hi, I am opening a HTML form fro

    Hi, I am opening a HTML form from WebFocus FEX procedure. When I open the HTML, I want to disable the close (X symbol) option at the right most corner of the form? How do I do that? Thanks Thambaiya
  3. rummage

    Function HHMMSS(A8)

    Thanks Frank van de Kant. I have done the code using the EDIT. It works. Thambaiya
  4. rummage

    Passing Amper variables between procedures

    Thanks PeterG5. I have done the code using the EDIT. It works. Thambaiya
  5. rummage

    Function HHMMSS(A8)

    Hi, I have this question: I am trying to create a unique ID for the session. For that I am concatenating UserID + Date + Time. For time, I use HHMMSS(A8). My code is like the following: -SET &AJB = GETUSER(A8) || &YMD || HHMMSS(A8); The problem is that HHMMSS results in a value that...
  6. rummage

    Passing Amper variables between procedures

    Thanks Eva and PeterG5 for the responses. I used the file method of getting the sessionID. It worked. I have this question: I am trying to create a unique ID for the session. For that I am concatenating UserID + Date + Time. For time, I use HHMMSS(A8). My code is like the following: -SET...
  7. rummage

    Passing Amper variables between procedures

    Hi , The following is my code of the first FEX procedure -SET &TODAY=&YMD; -SET &AJB = GETUSER(A8); -TYPE USER &AJB -TYPE &DATE -SET &SESSIONID = &AJB || &TODAY || 'AAAAAAAAAAAAAAAAAAAAAAA' SQL SQLMSS EX GOA01_SQL.dbo.spgoa_WF_Report_Fill_temp_0421 , '&SESSIONID', '&D1','&D2' ,0, 1...
  8. rummage

    Hi, Hi, From a FEX procedur

    When I try -MRNOEDIT -INCLUDE TESTREPO It gives me the following error. (FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: TESTREPOFOCEXEC * for second case- see if the html have the html formbegin and html form end . ----It is a HTML form with Javascript on it. When I run the HTML form...
  9. rummage

    Hi, Hi, From a FEX procedur

    Hi, Thanks for those answers. Still, my problem is not resolved. The code -MRNOEDIT -INCLUDE app/TESTREPO.htm gives me the following error: (FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: APP/testrepo.htm When I try -HTMLFORM TESTREPO The HTML form comes up. But the controls are not...
  10. rummage

    Hi, Hi, From a FEX procedur

    Hi, Hi, From a FEX procedure, I am calling a HTML form as follows -HTMLFORM TESTREPO.HTM When I was in the desktop, it was working fine. When I am trying to put the code in the server, the HTML is not displayed properly. What is wrong with the above Focus code? Should I have to...
  11. rummage

    Hi, I want to close a HTML from

    Thanks Eva. It works. Thambaiya
  12. rummage

    Simple 'Delete' does not work from WebFocus

    Hi, I am trying to delete a row from a SQL Server table. It does not work. My code is the following. -* CALL THE SQL PROCEDURE TO TRUNCATE THE TABLES SQL SQLMSS DELETE from DPCIOfInterest WHERE SESSIONGUID = '123456789AAAAAAAAAAAAAAAAAAAAAAAAAAA'; END -HTMLFORM BEGIN <HTML> <BODY>...
  13. rummage

    FEX failed

    Hi, I am running the following FEX procedure. -* File WF042102.FEX -* CALL THE SQL PROCEDURE TO TRUNCATE THE TABLES -SET &TODAY=&YMD; -SET &AJB = GETUSER(A8); -TYPE USER &AJB -TYPE &DATE -SET &SESSIONID = &AJB || &TODAY || 'AAAAAAAAAAAAAAAAAAAAAAA'; SQL SQLMSS EX...
  14. rummage

    Hi, I want to close a HTML from

    Hi Eva, This is my situation. I will include the code also. I have a HTML form that is used for accessing the reporting information from WebFocus. After I have seen the reports, I click a button called 'Clean Up and Close' on the HTML form. When I click the button, it is supposed to execute a...
  15. rummage

    Hi, I want to convey one of my l

    Hi, I want to convey one of my last issues clearly. From the HTML form, I am executing a FEX procedure. The FEX procedure execution is the last thing I want to do. So, I want to include the code in the FEX procedure to close the calling HTML form. How do I close the calling HTML form from the...

Part and Inventory Search

Back
Top