[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
strange PS code in SQR (redundant)
- Subject: strange PS code in SQR (redundant)
- From: the dragon <ceprn@HOTMAIL.COM>
- Date: Thu, 16 Sep 1999 13:27:39 CDT
Hi all,
A friend of mine is showing me some code (below) and asking what it does,
since the table does not appear to be defined in either Oracle or PS.
Anyone seen anything like this? What's with the ##PS_INTFC_BI_HT1 table
name? It exists in the biif0001.sqc bisetup3.sqc programs.
curious clark
BEGIN-SQL ON-ERROR=CANNOT-INSERT
INSERT INTO ##PS_INTFC_BI_HT1
SELECT [$Htmp_Fields]
FROM PS_INTFC_BI_HTMP
WHERE PROCESS_INSTANCE = #process_instance
AND TARGET_INVOICE = ' '
AND TRANS_TYPE_BI <> 'AHDR'
END-SQL
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com