Focal Point
[SOLVED] sql not working properly

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4877097626

December 03, 2012, 04:44 AM
expertomad
[SOLVED] sql not working properly
Good moorning , someone can help me .
this no ok .
TABLE FILE CAR
PRINT *
ON TABLE HOLD AS COCHE FORMAT ALPHA
END
-RUN
SQL SQLORA
SELECT *
FROM COCHE ;

(FOC1409) TABLA SQL NO ENCONTRADA. PARA TABLE REVISE SEGNAME Y TABLE
: ORA-00942: table or view does not exist
: Erroneous token: COCHE
L (FOC1405) ERROR PREPARE SQL.

I need have a hold and after use sql of this hold.

Thanks for all

This message has been edited. Last edited by: Kerry,
December 03, 2012, 05:22 AM
expertomad
i found the solution is
ON TABLE HOLD AS COCHE FORMAT SQLORA
December 03, 2012, 03:30 PM
Waz
Its amazing how talking it through, you can find your own solutions.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

December 04, 2012, 03:17 AM
expertomad
Yes , I was looking the forum a lot of hours ,and found the solution.
Good day