Vincent
|
| Posted: 07/01/2002, 3:23 PM |
|
I'm starting using codecharge studio 1.0.... There is one feature I can't find with CCS that is easily found in CC. How do you inner join between two table for a label and a grid form? I want to display a list of records, one of the fields comes from a different table. In Codecharge 2.0.5 you were going to the form-field properties, choose output tab and from there you could choose the table field you want to display also define where the join occurs using the join tab.
|
|
|
 |
Chris K.
|
| Posted: 07/01/2002, 3:27 PM |
|
In CCS you do it using Query Builder. You don't specify join for the control, but rather for whole grid. Select grid's properties, Data tab, choose Data Source, press '...' button to open properties window, after pressing 'Build Query' you can easily create complex joined queries, join all tables you need for grid and then after applying choose data source's fields for controls bindings.
|
|
|
|
|
