acme0101
|
| Posted: 05/08/2002, 9:17 AM |
|
I'd like to get some advice on how to best deal with data in multiple tables. For example, I have two tables that contain information about a user. One tables contains the login name, password, and security level. The other table contains information like first name, last name, address, etc.. I need to be able to display a form where the user can change any of this information.
Ideally, I'd like to have only one form, but I can't see how to do that easily with CodeCharge. If I use two forms, then it seems like its best to have them on two pages since each form gets their own "Insert", "Delete", etc. actions.
So, I can certaintly accomplish the functionality with multiple pages, its just not the UI that I was hoping for. Any ideas out there?
Thanks,
acme0101
|
|
|
 |
Nicole
|
| Posted: 05/09/2002, 5:31 AM |
|
Hello,
it's quite tricky and requires much manual coding. And I think it is possible in case if the values of user_id fields are the same in both tables.
You should create a form based on one table, and add as many empty not connection to db fields as many ones you want to be retrieved from second table. Then you should create custom show form event. Open new connection to db and select all the necessary fields and assign their value to field variables.
Note, that you should also create Custom Action event and duplicate insert, update, delete actions for second table as well.
|
|
|
|
acme0101
|
| Posted: 05/10/2002, 12:45 PM |
|
Thanks Nicole. You confirmed what I thought I had to do.
|
|
|
|
David King
|
| Posted: 09/07/2002, 3:43 PM |
|
Why doesn't CodeCharge handle this situation? It seems so common with a normalized data schema. For example, I'd like a DataGrid from, say, a User table and then a Form with both User and UserDetails table data fields on it. I really like CodeCharge, but if it can't handle this situation without a lot of manual coding, than it defeats the purpose of using it.
Thanks,
David
|
|
|
|
max
|
| Posted: 07/13/2003, 4:33 PM |
|
I am having an issue with updating multiple tables!
This issue has been reported before mutiple times, and it is an issue that is essential to web development.
Shouldn't CodeCharge have taken care of it in the latest release of Studio?!!!
Manual coding is quite cumbersome and makes it hard to convert the code to another language later!
Waiting for a reply!
Max
|
|
|
|
|
