klwillis
Posts: 428
|
Posted: 06/04/2004, 2:10 PM |
|
I'm currently using the CCDLookUp(...) function to display
a database column value on a page.
This works fine, but what if I want to display more than one?
I don't want to use CCDLookUp(...) multiple times for
each database field, and I don't want to have to add a
record form simply to display 2 fields from the database.
Is there a best way to do this?
_________________
Kevin Willis, VP/CIO
HealthCare Information Technology Specialist
http://www.nexushealthcare.com
"Fast - Convenient - Quality-Care"
Medical Software Consulting Services
Email : klwillis@nexushealthcare.com
Skype : klwillis2006 |
|
|
peterr
Posts: 5971
|
Posted: 06/04/2004, 5:07 PM |
|
It's usually best to use an SQL query that retrieves all necessary information at once. I believe that most of CCS examples utilize such queries, usually on the main page.
The Figure 11-5 at http://docs.codecharge.com/studio/html/UserGuide/Forms/FormDataSource.html is an example of how to setup multi-table queries using the Visual Query Builder, but you you can also enter your own SQL in the data source, which is also shown on that page.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
klwillis
Posts: 428
|
Posted: 06/04/2004, 7:50 PM |
|
That will work - but a form is required.
I thought this could be done without a form.
_________________
Kevin Willis, VP/CIO
HealthCare Information Technology Specialist
http://www.nexushealthcare.com
"Fast - Convenient - Quality-Care"
Medical Software Consulting Services
Email : klwillis@nexushealthcare.com
Skype : klwillis2006 |
|
|
|