Home » Developer & Programmer » Data Integration » crystal report error
crystal report error [message #116796] Fri, 22 April 2005 03:00 Go to next message
manjesh
Messages: 1
Registered: April 2005
Junior Member
hi iam manjesh. I am working with a project with front end as visual basic 6.0 and backend as oracle.in the connection with crystal report 4.5 i have faced problem

When passing query using "date" for eg: we have to obtain the details from oracle table using crystal report in the query the date format is not ok.it shows some error. I will give the sample query below

db.open "select * from "table name" where date >text1.text"

but this query shows some error please help me its very urgent

waiting for your reply
manjesh
Re: crystal report error [message #138007 is a reply to message #116796] Mon, 19 September 2005 06:29 Go to previous message
kiran
Messages: 503
Registered: July 2000
Senior Member
You should not hard code text1.text in the query.You should write like following.

db.open "select * from table_name where date > " & Format (Text1.Text,"DD-MMM-YY");

If not , post the error that you are getting.

--Kiran.
Previous Topic: Error RPE-01003
Next Topic: filecopy command
Goto Forum:
  


Current Time: Thu Mar 28 16:13:05 CDT 2024