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

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

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


Using Oracle SQL "WITH Clause"

21 August 2009 - 05:55 AM

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.

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

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?