Eric Bruno
|
| Posted: 05/11/2003, 12:59 AM |
|
I recently purchased CodeChargeStudio it's working well from me
except for the following problem. I used the Visual Query Builder
to left join some fields which are displayed as listboxes in the
maintenence (edit/update/delete) form created by the wizard.
When I attempt to generate the page I get the following errors:
The database is MySQL the language is php.
Warning:Insert is allowed for Record basictypes. 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 basictypes. 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 basictypes. 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.
It is not clear to me if this a setup problem with the query or
I need to do something with hidden fields in the form and actions.
|
|
|
 |
D K Systems Inc.
|
| Posted: 07/06/2003, 10:45 AM |
|
Eric,
The errors are generated because the Query is not updateable.
I also have a form which has a query as the record source and therefore need
to create Custom Insert, Update and Delete.
Have you found any documentation on writing Custom actions in CCS?
"Eric Bruno" <eric@ebruno.org> wrote in message
news:3EBE0269.50303@ebruno.org...
> I recently purchased CodeChargeStudio it's working well from me
> except for the following problem. I used the Visual Query Builder
> to left join some fields which are displayed as listboxes in the
> maintenence (edit/update/delete) form created by the wizard.
>
> When I attempt to generate the page I get the following errors:
> The database is MySQL the language is php.
>
> Warning:Insert is allowed for Record basictypes. 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 basictypes. 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 basictypes. 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.
>
> It is not clear to me if this a setup problem with the query or
> I need to do something with hidden fields in the form and actions.
>
>
|
|
|
|
|
