tOracleScript

[LRGood]

I put the following script into "Lines" at design time or at run time and I get a 942 error. If I trap the error and throw it into the bin bucket - no harm no foul. The view is created and I can look at it in pl/sql. If i run the script in pl/sql I get no error

CREATE VIEW I127_1 AS
SELECT F.Series_Key, F.Formula_Key, L.Amount AS IAMT_1
FROM Formula F, Ingrd_Level L, Ingrd I
WHERE F.Formula_Key=L.Formula_Key
AND I.Ingrd_Key=L.Ingrd_Key
AND I.Chem_Synonym_Key=2839
AND L.Amount>=0 AND L.Amount

 

[Marco Kalter]

Could it be that there is something else in the script? The ORA-00942 would indicate that a non-existent table is accessed, which cannot happen if your view is correct.

------------------
Marco Kalter
Allround Automations

 

[LRGood]

I created a tSringlist variable, "lWhere", and did AddStrings to the tOracleScript. I did something very dumb. I forgot to clear "Lines" prior to the addstrings. Put in the clear and it works as it should

Thanks