IT SOLUTIONS
Your full service technology partner! 
+Expand
   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardQBE & SQL Topic   Print This     

Using embedded SQL with reports?

Using embedded SQL with reports? in QBE & SQL topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: embedded   reports   Using embedded   Using embedded SQL  
Dante
 (Inactive)
South - Africa

I have the following problem:

I have to use embedded SQL in a program, and then I have to base a report on the results of the SQL. The problem that I have is that the results from the SQL are stored in a temp Answer.db table. So I cant use the report designer in Paradox.

How can I create a report on the results from the SQL?

 Posted 22 years ago (Thread Starter)
Comment Quote
About Dante +Expand
Location=South - Africa  
Joined=22 years ago   MB Posts=17  
Tony M
 (Inactive)
 Posted 22 years ago
Comment Quote
About Tony M +Expand
Location= 
Joined=23 years ago   MB Posts=410   KB Comments=1  
Tony M
 (Inactive)
 Posted 22 years ago
Comment Quote
About Tony M +Expand
Location= 
Joined=23 years ago   MB Posts=410   KB Comments=1  
Dante
 (Inactive)
South - Africa
Yes I could run the SQL once and then base the report from that, but you see the problem is that at run time a user selects certain values and options, from which the SQL is then dynamically created. So I cant run the SQL before hand.

And then the report hsould also by dynamically created from the results from the SQL.

Maybe I could change the name from the Answer table to something else but then, how do build the report at run time?
 Posted 22 years ago (Thread Starter)
Comment Quote
About Dante +Expand
Location=South - Africa  
Joined=22 years ago   MB Posts=17  
Dante
 (Inactive)
South - Africa
Well if thats the way it's gotta be :-)

Thanks for the help, just one more question.

Where can i find an example of code that manipulates reports at run-time. This is my first time using Opal, so I'm still learning.
 Posted 22 years ago (Thread Starter)
Comment Quote
About Dante +Expand
Location=South - Africa  
Joined=22 years ago   MB Posts=17  
Most Recent Post
Dante
 (Inactive)
South - Africa
I saw in the Help files that there is a report open statement, that specifies a SQL string as a argument? Does anyone know if this could help me?
 Posted 22 years ago (Thread Starter)
Comment Quote
About Dante +Expand
Location=South - Africa  
Joined=22 years ago   MB Posts=17  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P195A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #9444 Counter
2927
Since 4/2/2008

Regarding...

Linked Knowledge Base Article.

This thread is linked to the following KB article.


Mike Prestwood
1. Power: Chapter 24, SQL and Client/Server Applications

Chapter 24 "SQL and Client/Server Applications" of Paradox 9 Power Programming by Mike Prestwood.

Posted to KB Topic: P9 Book: Power Programming
22 years ago, and updated 15 years ago
(3 KB Comments)

KB Post
Nothing New Since Your Last Visit
25225
Hits

Corel Paradox / ObjectPAL Coding

Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2025 Prestwood IT Solutions.   [Security & Privacy]