Query in Command

building reports crystal reports
1

Hi All,

For a report development,User had provided a query to use in the report.
I have added this to command and executed query.

Issue is in the Database expert.I have opened command window and added query to it and after clikcing OK button window is closing after so much of time.What will happen after adding query to command?Is this query going to execute against database or just compiles the query?

Could anyone please answer my question?

Please let me know if anyone needs in detail.

Thanks in advance.

siva6809 (BOB member since 2009-03-05)

2

when you click ok button after adding the query in command prompt , crystal will connect to the db and checks for the SQL syntax. you will get error message if the sql is incorrect. if everything is fine, then the table will be created and you can proceed with the next step to create the report.

hope you understood the process.

Muna :india: (BOB member since 2008-08-05)

3

Hi Naaz,

Thank you so much for your quick reply.

Its taking so much time to check the SQL syntax.What might be the reason behind this to take so much of time?

Note that my query doesn’t have any syntax error.Its perfectly working.

If you know about this could you answer my question,Please?

Could you please give me suggestions?

siva6809 (BOB member since 2009-03-05)

4

Hi,

Can anyone reply please?

siva6809 (BOB member since 2009-03-05)

5

can you paste the query here?
How much time it takes to run the query in sql interface?

asujata1 (BOB member since 2008-07-21)