Home » Developer & Programmer » Reports & Discoverer » Plz help me to find the error in the sql statement of DATA MODEL
Plz help me to find the error in the sql statement of DATA MODEL [message #89527] Tue, 04 May 2004 02:54 Go to next message
dipankar saha
Messages: 36
Registered: March 2004
Member
hi to all,

i am getting a error while running the sql satemnt in the data model of my report , the sql satemnt is as follows:-

SELECT ALL BORROW_REGISTRY.RECV_EMP_NO,
BORROW_REGISTRY.RECV_EMP_NAME, BORROW_REGISTRY.RETURN_DATE, FROM BORROW_REGISTRY where ((BORROW_REGISTRY.FLAG = 1)
 AND &param_prdname );

and the error given is:-

ora-00911-invalid character                                           where ((BORROW_REGISTRY.FLAG = 1)

plz can anyone tell me what is wrong in the sql statement.

 

 

Report message to a moderator

Re: Plz help me to find the error in the sql statement of DATA MODEL [message #89534 is a reply to message #89527] Thu, 06 May 2004 02:50 Go to previous message
NE1
Messages: 1
Registered: May 2004
Junior Member
what datatype is BORROW_REGISTRY.FLAG

if its varchar then change to = '1'

Report message to a moderator

Previous Topic: Dont show report
Next Topic: A doubt on forms and reports
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 03:39:57 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.