Elmar
Posts: 17
|
| Posted: 09/06/2005, 7:27 AM |
|
Hi...again 
I just need a hint how to solve the following problem. Letīs say you want to build a runners dairy.
You have a table representing one exercise. Additionally there is a table that should fill a drop down field where you can choose from a list of options regarding the training level (low, medium, high) and some other tables definining similar values like own condition, weather etc..
All these additional tables should be linked together by the approriate ID in the 'exercise table'.
How do I get them displyed together in one SQL without double entries? Is there a tutorial somewhere?
Thanks in advance,
Elmar
|
 |
 |
Elmar
Posts: 17
|
| Posted: 09/07/2005, 5:39 AM |
|
Maybe I have to clarify this...
table exercise:
| id | name |
--------------------
| 1 | warmup |
--------------------
| 2 | cooldown |
table exercise_elements:
| exercise_id | text |
----------------------------------
| 1 | dips |
| 1 | situps |
| 2 | stretching |
So an exercise has one id, a name and several elements.
How do I represent this in a code charge component (record, grid)? Writing back to exercise and to elements?
Thanks,
Elmar
|
|
|
|
peterr
Posts: 5971
|
| Posted: 09/07/2005, 11:40 AM |
|
I think that you mixed up too many topics, so it's little hard for me to understand everything that you may need. Grid, Record, Listbox are all different entities.
It may be best if you start with the tutorials in the documentation. The 2nd tuorial is the best. All this is also online at http://docs.codecharge.com/studio/html/QuickStart/Creat...AppBuilder.html
It demonstrates how to display data from multiple tables, for example: http://docs.codecharge.com/studio/html/QuickStart/Creat...citRelship.html
In some cases you may need to use your own SQL that groups the data the way you want. Just change the data source to SQL and type the SQL that you want to use.
Listboxes are simple to setup - just change any of your fields into a Listbox, then fill-in its properties:
http://docs.codecharge.com/studio/html/QuickStart/Creat...stBoxField.html
http://docs.codecharge.com/studio/html/QuickStart/Creat...stBoxField.html
The Record form cannot update multiple tables, thus you should always use one table as the basis of your Record form, plus listboxes wherever needed. Occasionally you may need to use a query as your Record's basis, and then specify which table to update in the Custom Insert/Update property.
If you need to update additional tables separately, you may need couple lines of code. In such case I recommend that you post your question to the appropritae forum and someone knowing the particular programming language may be able to help.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Elmar
Posts: 17
|
| Posted: 09/08/2005, 12:36 PM |
|
Thank you, Peter. I was finally able to reproduce the example "many-to-many listboxes" that comes with the CC-Installation. That was just the explanation I needed.
It just takes time to get a feeling for the CC-Framework. Once you get a grip it is really good to use.
Actually I would advertise CodeCharge also as a handy Framework with included IDE.
Bye,
Elmar
|
|
|
|
Walter Kempees
|
| Posted: 09/08/2005, 1:13 PM |
|
Quote :
Actually I would advertise CodeCharge also as a handy Framework with
included
IDE.
(just kidding:) wait till you check out CodeCharge Studio
Hey sorry after a long hard dayworking, I needed to post a funny note.
Walter
|
|
|
|
Elmar
Posts: 17
|
| Posted: 09/09/2005, 4:27 AM |
|
Got me!
|
|
|
|
|
