Jump to content


Vlodik Myslony

Member Since 23 Dec 2002
Offline Last Active Nov 22 2010 03:35 AM
-----

Topics I've Started

Zero being converted to 80000

26 August 2009 - 07:14 AM

Hi,
we have an issue where the value in an oracle table is set to zero, but 80000 is being inserted.

e.g. column_value = 0
IF column_value > 0 THEN
UMSG(CONV(column_value),-1)
ENDIF

The above is returning 80000 but only on some records when scanning through many records.
Any ideas?

Thanks

Using Oracle SQL "WITH Clause"

21 August 2009 - 05:55 AM

Hi,
Has anyone succeeded in using the "WITH" Clause within your imbedded sql in ProIV.

I am currently using Proiv 6.2 on Oracle 10g.
The ProIV trace file shows the SQL being parsed correctly but proIV returns the old 366 Oracle SQL error.


SQL
WITH subquery_name AS (the aggregation SQL statement) SELECT (query naming subquery_name);
ENDSQL

How to access Version 6 Lists via updates

16 February 2009 - 09:20 AM

In ProIV version 5 and below it was possible to load lists of functions into dctf.pro for the purpose of having our own export lists and linking into the ProIV Re-Gen or Export functionality.
Does any know how to update the version 6 files containing the lists which can link to the bulk build?

Thanks