dprice
|
| Posted: 07/08/2005, 7:35 AM |
|
I'm trying to develop a client information application using the directory in the css solutions example.
The reason I'm using is because we have well over 130 clients and this is the easiest way for account managers to find their respective clients since it is sorted alphabetically by the parent id.
The only difference I'm trying to make is that in the example it uses a non-editable simple grid, and I would like the account executives to be able to change certain information once they have selected the client.
I am able to remove the grid and replace it with an editable grid but when I build it I immediately get errors and the submit button used for inserting, editing, etc is removed.
I am relatively new at this, and would appreciate any help. Our organization is really using these tools I am creating with ccs and I need to keep them rolling out.
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 07/08/2005, 8:54 AM |
|
Please read the error messages as they should help you understand the problem. No one else can see those errors and therefore probably cannot answer such questions.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
dprice
|
| Posted: 07/08/2005, 8:57 AM |
|
Warning: Insert is allowed for Record qryClientData. Unable to build Insert based on the current Datasource settings (joins, SP or custom SQL). Change the Allow Insert property to disable Insert or specify Custom Insert.
Warning: Update is allowed for Record qryClientData. Unable to build Update based on the current Datasource settings (joins, SP or custom SQL). Change the Allow Update property to disable Update or specify Custom Update.
Warning: Delete is allowed for Record qryClientData. Unable to build Delete based on the current Datasource settings (joins, SP or custom SQL). Change the Allow Delete property to disable Delete or specify Custom Delete.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 07/08/2005, 9:20 AM |
|
That's what I suspected. Those errors/warnings explain what to do, and my answer would be the same.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
dprice
|
| Posted: 07/08/2005, 9:44 AM |
|
I've changed the the join, with no success, and the other two don't apply. I was hoping that someone here could tell me specifically why this is happening as I really need to get this working.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 07/08/2005, 10:04 AM |
|
Specifically this is most likely happening because your grid contains a SELECT statement with multiple tables/joins. Therefore it may not be possible to use such SQL to update the database. You will need to either:
a) use one table as the Editable Grid's data source so that that table can indeed be updated.
or b) disable Updates/Inserts since they cannot be performed due to your SQL.
or c) Use Custom Insert/Update/Delete and specify there which one of those tables you'd like to insert/update/delete the data from.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
