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!

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

Search results for query: *

  • Users: rummage
  • Content: Threads
  • Order by date
  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)

    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...
  4. 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...
  5. 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...
  6. 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>...
  7. 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...
  8. 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...
  9. rummage

    Parameters to pass

    Hi, When I execute a FEX procedure from a HTML form (I am going to code it in the OnUnload event of the HTML form), How should the code be? Thanks Thambaiya
  10. rummage

    Error(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: DPCIIN FOCEXEC *

    Hi, I am trying to run a WebFocus FEX procedure from a push button of HTML form. My code in the push button click is the following function ClickButton1() { window.location.href = &quot;http://wapux003.target.com/cgi-bin/ibi_cgi/ibiweb.exe?IBIF_ex=DPCIIN&quot;; } where DPCIIN is the FEX...
  11. rummage

    Hi, In the 'On Unload' event of

    Hi, In the 'On Unload' event of an HTML page, I am calling a WebFocus procedure (FEX procedure). It is not working. I want to call the FEX procedure when the user closes the HTML form. In which event I need to code? Here is my entire code for your reference. //Javascript call function...
  12. rummage

    Hi, I want to close a HTML from

    Hi, I want to close a HTML from from Webfocus. What is the syntax? Thanks Thambaiya
  13. rummage

    Passing parameter to HTML from WebFocus

    Hi, I am calling a HTML form from my Webfocus/Focus code. I want to pass parameters to the HTML form from the focus code. How do I do it? Thanks in advance. Thambaiya
  14. rummage

    Hi, I am trying to execute a SQL

    Hi, I am trying to execute a SQL Server Stored procedure from WebFocus. The SQL stored procedure inserts a row in one of the tables in the databse. My code is as follows SQL SQLMSS BEGIN SESSION EX GOA01_SQL.dbo.spgoa_Insert_DPCIOfInterest 'E0C7EBAA-1236-4AE5-ABD3-01DF39E135A3','81','7',''...
  15. rummage

    Results of SQL Server Stored Procedure Call

    Hi, I am executing two different SQL Stored procedures from WebFOcus. I want to get the results of both the stored procedures in one output report file. How do I do that? Here is my code SQL SQLMSS EX GOA01_SQL.dbo.spgoa_GetSummaryDataA '30A882AA-D6F7-4A34-8F71-4157C6CEDE27',0; TABLE FILE...
  16. rummage

    Hi, I am passing a variable to a

    Hi, I am passing a variable to a SQL Server store procedure. I am getting a syntax error at the EX statment. What could be the reason? The code is the following SQL SQLMSS -DEFAULT &SESSIONGUID = 40709297-9D5F-4D26-BF76-9159F0D664D9 EX GOA01_SQL.dbo.spgoa_GetSummaryDataA '&SESSIONGUID',0...
  17. rummage

    Hi Folks, I am trying to call a

    Hi Folks, I am trying to call a SQL stored procedure from WebFocus using two parameters. The parameters are '40709297-9D5F-4D26-BF76-9159F0D664D9','0' It is giving me two errors. First when I save this, it says 'One of the line is longer than 80 char. Do you want to save?' After I save and...
  18. rummage

    How can I call a SQL stored procedu

    How can I call a SQL stored procedure from Webfocus? I need the code. Thanks

Part and Inventory Search

Back
Top