Accessing data in Oracle

[cubi]

Hi,

I get the following error in my application:

Error Diagnostic Information
ODBC Error Code = S1000 (General error)


[Oracle][ODBC][Ora]ORA-00923: FROM keyword not found where expected

SQL = "SELECT DISTINCTROW Agency_grp.Agency_grp_id, Agency_grp.Agency_grp_name
FROM Program , Agency_grp, Activity, Agency, User_agency_grp
WHERE Agency_grp.Active_status='A' AND User_agency_grp.agency_grp_id=Agency_grp.Agency_grp_id AND User_agency_grp.Username='lhoang' AND User_agency_grp.Active_status='A' ORDER BY Agency_grp.Agency_grp_id;"

Data Source = "BDPMRS"

The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:59) in the template file C:\INETPUB\

http://WWWROOT\FORMS\INCLUDE\QUERYAGENCYGRP.CFM.

I just converted my database from Access 97 to Oracle. The above query worked fine in the Access database. Do I need to modify it to read data from Oracle?

Thanks

 

[jgroove]

cubi,

Try changing the function DISTINCTROW to DISTINCT. Oracle does not support the DISTINCTROW function that is in Access.


I have found this page of help in the past. It is a comparison between Oracle and Access.

http://www.cse.bris.ac.uk/~ccmjs/ora_sql.htm

jgroove