Marcello Capelati
|
| Posted: 11/27/2002, 9:30 AM |
|
I have a Record Form, with many fields (text box and label fields) witch I want to input some values on them Before Show the form.
Many of these fields are from the same table.
I put my Custom Code on the page's "Before Show" event: many calls to CCDLookUp(), one for each field.
Everything works fine, but I'd like to improve this code, making just one call (and just one SQL), so:
- Do I have to make all these calls to CCDLookUp() functions, or is there any function to do this with just one single SQL call, retrieving all the table rows I need ?
- I tried to do this with CCGetListValues() functiom, but I can't make this work ! - I don't know how to use it, and there is no good information at manuals nor here at forum...
Thank ya.
|
|
|
 |
AndrewI
|
| Posted: 11/28/2002, 8:18 AM |
|
What I think you need is CCOpenRS()
You can open a recordset containing several fields (and several records if need be) in one operation.
As to usage... well the syntax is outlined in help. I'm struggling to make it work at this very moment - if you get there before I do, post an example in codechargers.com!
Rgds
Andrew
|
|
|
|
|
