Damian Hupfeld
|
| Posted: 04/18/2005, 4:10 PM |
|
Warning: Update is allowed for Record adv1. 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.
Please see page:
http://www.crewaustralia.com.au/bus/update.php
login as
fri3@itng.com.au/monday
All data is pulled from 1 table called ADV.
There is a value called Level in which I store an Integer (1, 11, 111, 1111)
but I want to display a Text Value. I changed my source to ADV left join
LEVEL so that I could display Silver partner instead of 11. Now my Update
function is disabled!
I have no idea how to do Custom Insert statement.
|
|
|
 |
Damian Hupfeld
|
| Posted: 04/18/2005, 4:17 PM |
|
Also I do NOT want this FORM to be able to update the LEVEL field - just
display the current Level.
"Damian Hupfeld" <damian.hupfeld@itng.com.au> wrote in message
news:d41eog$n3b$1@news.codecharge.com...
> Warning: Update is allowed for Record adv1. 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.
>
> Please see page:
> http://www.crewaustralia.com.au/bus/update.php
> login as
>fri3@itng.com.au/monday
>
> All data is pulled from 1 table called ADV.
> There is a value called Level in which I store an Integer (1, 11, 111,
> 1111) but I want to display a Text Value. I changed my source to ADV left
> join LEVEL so that I could display Silver partner instead of 11. Now my
> Update function is disabled!
>
> I have no idea how to do Custom Insert statement.
>
>
|
|
|
|
peterr
Posts: 5971
|
| Posted: 04/18/2005, 4:44 PM |
|
You cannot update SQL queries, only tables.
Thus create Custom Update (not Custom Insert) statement as specified.
> I have no idea how to do Custom Insert statement.
Open the Custom Update dialog and click OK. It's that simple.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
Damian Hupfeld
|
| Posted: 04/18/2005, 5:20 PM |
|
I was sort of thinking that...
Any other idea on how I might achieve this?
From a display point of view when I add the second table into the source I
can display the info fine - but then I cannot allow the user to update ANY
records. If I made the LEVEL into a LIST box then I can INSERT and DISPLAY
the right value - BUT I dont want the user to be able to change his level!
"peterr" <peterr@forum.codecharge> wrote in message
news:5426446790ea45@news.codecharge.com...
> You cannot update queries, only tables.
> Thus create Custom Update (not Custom Insert) statement as specified.
>
>> I have no idea how to do Custom Insert statement.
>
> Open the Custom Update dialog and click OK. It's that simple.
> _________________
> Peter R.
> YesSoftware Forums Moderator
> For product support please visit http://support.yessoftware.com
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Nicole
Posts: 586
|
| Posted: 04/19/2005, 2:47 AM |
|
Damian,
You can make a listbox disabled when form is set to Edit Mode. Add template variable to <select> tag in HTML mode. In form’s Before Show event check the form’s mode (EditMode or not) and depending on it substitute template variable with "disabled" keyword. CCS Help provides sample code for setting value of template variable
http://docs.codecharge.com/studio/html/Components/Varia...HP/Tpl.html?toc
The other way is to create Custom Update and exclude field that corresponds a listbox from Update statement.
_________________
Regards,
Nicole |
|
|
|
|
