problem with oracle dataset in visual studio 2005This is a discussion on problem with oracle dataset in visual studio 2005 within the Oracle forums in Oracle Database category; i'm newbie in oracle and visual studio 2005... my problem is: i running a sql-query in visual studio 2005 with the oracle dataset.. i want the data that displayed is in the date range and the parameter is set by user.. but i dunnoe why my query has problem.. EXEC (' SELECT DISTINCT XNP_TIMER_VIOLATION.VIOLATION_TIME, ... FROM XNP_TIMER_VIOLATION, ... WHERE (DATEADD(hh, 8,XNP_TIMER_VIOLATION.VIOLATION_TIME) BETWEEN ? AND ?)',@FROM_DATE, @TO_DATE ) AT npcrpt ; i hope someone can help me...plz... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
06-02-2008, 04:41 AM
|
 problem with oracle dataset in visual studio 2005 i'm newbie in oracle and visual studio 2005... my problem is: i running a sql-query in visual studio 2005 with the oracle dataset.. i want the data that displayed is in the date range and the parameter is set by user.. but i dunnoe why my query has problem.. EXEC (' SELECT DISTINCT XNP_TIMER_VIOLATION.VIOLATION_TIME, ... FROM XNP_TIMER_VIOLATION, ... WHERE (DATEADD(hh, 8,XNP_TIMER_VIOLATION.VIOLATION_TIME) BETWEEN ? AND ?)',@FROM_DATE, @TO_DATE ) AT npcrpt ; i hope someone can help me...plz   |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -4. The time now is 08:40 PM.
