Aspx and datasource editor

sbslavonac · Post by **sbslavonac** » Fri 08 May 2009 11:57

Hi,
I do not know if this is a bug or what but I have lost considerable amount of time with this.
Kept getting ORA-01008: not all variables bound in ds editor.

Created new datasource:
SELECT '1' UVJET, S.ID_HOTEL, R.ID_SOBA, A.ID AS ID_HOTEL_SOBA, R.ID_SOBA_USLUGA, S.ID_ARANZMAN, R.ID, R.DATUM_OD, R.DATUM_DO,
R.IZNOS_PERIOD, A.SOBA, G.OPIS AS USLUGA,
'BROJ OSOBA ' || A.OSOBA || DECODE (A.MAX_DODATNO, 0, '', '+(' || A.MAX_DODATNO || ')') AS MAX_OSOBA, R.LAST_MINUTE
FROM WEB_RASPOLOZIVO R,
WEB_SOBA_USLUGA G,
WEB_HOTEL_SOBA S,
WEB_SOBA A
WHERE R.ID_SOBA_USLUGA = G.ID
AND R.ID_SOBA = S.ID
AND S.ID_SOBA = A.ID
AND R.DATUM_OD IN (SELECT MIN (r.DATUM_OD)
FROM WEB_RASPOLOZIVO R
WHERE
(DATUM_OD = :DATUMOD) AND EXISTS (SELECT ID
FROM WEB_HOTEL_SOBA A WHERE A.ID_HOTEL = :IDHOTEL AND R.ID_SOBA = A.ID)

GROUP BY ID_SOBA)
AND R.DATUM_OD = :DATUMOD
AND EXISTS (SELECT ID FROM WEB_HOTEL_SOBA A WHERE A.ID_HOTEL = :IDHOTEL AND R.ID_SOBA = A.ID)

Lines marked red gave me trouble.
When I changed from

(DATUM_OD = :DATUMOD) AND EXISTS (SELECT ID
FROM WEB_HOTEL_SOBA A WHERE A.ID_HOTEL = :IDHOTEL AND R.ID_SOBA = A.ID)

to

(R.DATUM_DO>=:DATUMOD)
AND EXISTS (SELECT ID
FROM WEB_HOTEL_SOBA A WHERE A.ID_HOTEL = :IDHOTEL AND R.ID_SOBA = A.ID)
AND (r.DATUM_OD <= :DATUMOD)
Everything worked.
Any comments
Best regards
Boris

Shalex · Post by **Shalex** » Tue 12 May 2009 15:52

There was a bug in the 4.x versions of dotConnect for Oracle: the similar error arose if the same variable was used several times in the query in the direct mode. It is fixed in the latest versions. Please specify your current version, the mode (direct or not) you use. Does this problem persist with the latest 5.20.29 version of dotConnect for Oracle?

sbslavonac · Post by **sbslavonac** » Tue 12 May 2009 19:12

Sorry I forgot to mention :
Win XP
Visual studio 2008, sp1, net 3.5
5.20.29 dotnet
direct mode

Shalex · Post by **Shalex** » Thu 14 May 2009 09:56

It seems like the mentioned problem persists in the current build. I will notify you about the results of our investigation.

Shalex · Post by **Shalex** » Thu 14 May 2009 12:28

The issue with repeating parameters of OracleCommand in the Direct mode is fixed. Look forward to the next build of dotConnect for Oracle that will be available in a week.

Shalex · Post by **Shalex** » Fri 22 May 2009 15:55

The new build of dotConnect for Oracle 5.20.33 is available for download now.
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=14909 .