VBAjedi
Posts: 34
|
| Posted: 05/27/2004, 11:39 AM |
|
I have an editable grid for a table in my dbase. One of the dbase fields (which I have represented in my editable grid with a label so that it is not editable) contains an index number that corresponds to a text value in another table.
How can I get the text value from the second table to appear in the label instead of the index number? Since it's an editable grid, I don't think I can link to the second table in the data source for the grid (since it would require custom insert/update/delete code, which I've never seen done).
Is there a way to make the label have a seperate data source like you can do with List Boxes? Or how is this done? It surely must be a fairly common need. . .
_________________
VBAjedi
jedi at NOSPAM dot obie dot com |
 |
 |
VBAjedi
Posts: 34
|
| Posted: 05/28/2004, 11:55 AM |
|
I should add that for the moment I have converted the label to a listbox and set the datasource to the other table. By disabling the listbox I can at least let the user see the value in a grey font. But aside from the obviously cheesy look this presents, it also has an impact on the page load time because the listbox on each row has 30+ entries in it that I don't need.
I definitely need a better approach!
_________________
VBAjedi
jedi at NOSPAM dot obie dot com |
|
|
|
peterr
Posts: 5971
|
| Posted: 05/28/2004, 12:11 PM |
|
I would recommend that you try modifying the data source and then figure out configuring your Custom Insert/Update/Delete.
Another method would be to lookup the field value as shown at http://docs.codecharge.com/studio/html/ProgrammingTechn...gleDBValue.html , but this method would be slower because it would execute one SQL query for each row.
I haven't tried any of these methods with Editable Grid therefore this is just an idea.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
VBAjedi
Posts: 34
|
| Posted: 05/28/2004, 12:27 PM |
|
I'd really like to figure out the Custom Insert/Update/Delete function of CCS (for editable grids). However, I have never been able to find an actual example of it - even in the CCS site or example pack. Anything you can point me to?
FWIW, the lack of inline examples in the help files has been my biggest beef with CCS. I certainly hope that's going to be corrected in the next version. . .
_________________
VBAjedi
jedi at NOSPAM dot obie dot com |
|
|
|
peterr
Posts: 5971
|
| Posted: 05/28/2004, 12:36 PM |
|
Just click on "Custom Insert". It's pretty straightfoward and actually fills itself out automatically. An example is probably not needed because you don't need to do anything just click "OK", unless you want to change it. If you want to change it then there is usually a reason for this and it's difficult to create an example without understanding how someone is using it.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
