Home » Developer & Programmer » Forms » error files compare (frms 11gr2)
error files compare [message #611028] Thu, 27 March 2014 01:35 Go to next message
pre_ora
Messages: 56
Registered: March 2014
Member
i have compiled forms from older version to latest version
and error files are generated for each form.. mentioning last line /phrase if it is successful or error occurred..

As there are 1000+ files i want to compare them to distinguish result of each form so that i can understand which form is require to edit and compile mannually
i know comp command on dos
like
comp \invoice\*.txt \invoice\backup\*.txt /n for no of first lines ...

how can i check last line of each error file?

i.e; how can i check a phrase from multiple files in same dir?

[Updated on: Thu, 27 March 2014 01:37]

Report message to a moderator

Re: error files compare [message #611030 is a reply to message #611028] Thu, 27 March 2014 02:43 Go to previous messageGo to next message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Here's an example.

I created two TXT files which represent your error files:
This is text.txt
SELECT *
  FROM zahtjevi
 WHERE datum_unosa BETWEEN SYSDATE - 3 / 24 AND SYSDATE; -- the last line in test.txt

This is test1.txt
SELECT SYSDATE,
       cnt cnt_zahtjeva,
       ROUND (cnt / (SYSDATE - min_datum_unosa), 1) avg_dnevno
  FROM test; -- the last line in test1.txt


This is a batch script which displays the last line in all TXT files in current directory ("all" files are these two files I created: TEST.TXT and TEST1.TXT):
@echo off
set LASTLINE=
setlocal enabledelayedexpansion
for %%a in (*.txt) do (
echo %%a
for /f "delims=" %%s in (%%a) do set LASTLINE=%%s
call echo !LASTLINE!
)


Finally, execution:
M:\>last_line
test.txt
 WHERE datum_unosa BETWEEN SYSDATE - 3 / 24 AND SYSDATE; -- the last line in test.txt
test1.txt
  FROM test; -- the last line in test1.txt

M:\>

Re: error files compare [message #611035 is a reply to message #611030] Thu, 27 March 2014 03:07 Go to previous messageGo to next message
pre_ora
Messages: 56
Registered: March 2014
Member
solved...
Re: error files compare [message #611036 is a reply to message #611035] Thu, 27 March 2014 03:08 Go to previous message
pre_ora
Messages: 56
Registered: March 2014
Member
thank you...Littlefoot
Previous Topic: clearing text item
Next Topic: running forms on web browser
Goto Forum:
  


Current Time: Fri Apr 19 01:07:33 CDT 2024