Aspx and datasource editor

Aspx and datasource editor

Postby 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 (R.DATUM_DO >= :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 DATUM_DO >= :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 (R.DATUM_DO >= :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
sbslavonac
 
Posts: 34
Joined: Mon 02 Apr 2007 09:14

Postby 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?
Shalex
Devart Team
 
Posts: 7208
Joined: Thu 14 Aug 2008 12:44

Postby 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
sbslavonac
 
Posts: 34
Joined: Mon 02 Apr 2007 09:14

Postby 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
Devart Team
 
Posts: 7208
Joined: Thu 14 Aug 2008 12:44

Postby 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
Devart Team
 
Posts: 7208
Joined: Thu 14 Aug 2008 12:44

Postby 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 .
Shalex
Devart Team
 
Posts: 7208
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle