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
- ProIV Resource Centre
- → Viewing Profile: Topics: Vlodik Myslony
Community Stats
- Group Members
- Active Posts 5
- Profile Views 3,845
- Member Title Newbie
- Age 68 years old
- Birthday February 18, 1957
-
Gender
Male
-
Location
Australia
Previous Fields
-
First Name
Vlodik
-
Surname
Zmyslony
-
Year Started ProIV
1992
-
Highest ProIV Version Used
6.1
-
Company Working For
IOOF
0
Neutral
User Tools
Friends
Vlodik Myslony hasn't added any friends yet.
Latest Visitors
Topics I've Started
Zero being converted to 80000
26 August 2009 - 07:14 AM
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
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
Does any know how to update the version 6 files containing the lists which can link to the bulk build?
Thanks
- ProIV Resource Centre
- → Viewing Profile: Topics: Vlodik Myslony
- Privacy Policy