Dante Sandigan
|
| Posted: 08/19/2001, 10:44 PM |
|
Hi to all.
I would like to disable some fields (specifically text fields) in a CC
record form which is in insert mode. How can I do this.
Thanks for any help.
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 08/20/2001, 2:37 AM |
|
If you're in insert mode - this means that all fields in the form
are empty , so you just don't add to form those text fields, since
they're empty anyways, no use to show empty non-editable fields.
--
Alex
Ceritfied CodeCharge Developer
Develop database-connected web sites
without coding: http://www.codecharge.com
ASP, ASP.NET, PHP, JSP, Perl, ColdFusion
Dante Sandigan <disandigan@loyolaplans.com> wrote in message
news:9lq84o$prn$1@news.codecharge.com...
> Hi to all.
>
> I would like to disable some fields (specifically text fields) in a CC
> record form which is in insert mode. How can I do this.
>
> Thanks for any help.
>
>
|
|
|
|
Dante S.
|
| Posted: 08/20/2001, 6:44 AM |
|
Hi Alexey,
Thanks for the help. If I don't include the fields as textbox fields, they
won't be included in the insert and my database will report errors telling
me that null values are not allowed. I assigned values to these fields in
the Before Show Insert event, so on the form the textbox fields shows these
values and I don't want the user to change them.
I tried defining them as labels and the problem is they're not included in
the insert procedure of CC. I hope I am clearer this time.
- Dante
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:9lqlom$j0a$1@news.codecharge.com...
> If you're in insert mode - this means that all fields in the form
> are empty , so you just don't add to form those text fields, since
> they're empty anyways, no use to show empty non-editable fields.
>
> --
> Alex
> Ceritfied CodeCharge Developer
> Develop database-connected web sites
> without coding: http://www.codecharge.com
> ASP, ASP.NET, PHP, JSP, Perl, ColdFusion
>
|
|
|
|
Frank Rocco
|
| Posted: 08/20/2001, 8:22 AM |
|
Hi Dante,
I got around this by changing the database fields to hidden and assigning
the values to labels on the form so the user could see them, but would not
be able to change them.
HTH
Frank
|
|
|
|
Dante S.
|
| Posted: 08/20/2001, 10:56 AM |
|
Thanks Frank.
This is what I have done but I don't know why I get the error null values
not allowed from my database server (I'm using Oracle 8i). I checked the
generated code and I found out that the fields which are defined as label in
CC is not included in the insert module. I just realized that I defined
these fields as key fields and that's the reason why CC did not include them
in the insert sql statement. But when I unchecked the primary key tag
checkbox for these fields, my form behaves errantly (it does not display the
record form for the record selected from a grid form -- it always displays
the first record in the grid). Hope you can shed more light as to what I am
doing wrong. Thanks again.
- Dante
"Frank Rocco" <farocco@hotmail.com> wrote in message
news:9lra06$rl6$1@news.codecharge.com...
> Hi Dante,
>
> I got around this by changing the database fields to hidden and assigning
> the values to labels on the form so the user could see them, but would not
> be able to change them.
>
> HTH
>
> Frank
>
>
|
|
|
|
Alexey Alexapolsky
|
| Posted: 08/22/2001, 4:51 AM |
|
Open Before insert event form your own sql statement
consisting of fldsomething variables and nulls in places of
non-editable variables.
smth like $sSQL = "insert into table (name,price) values ('$fldname',null)"
--
Alex
Dante S. <dante@emailko.com> wrote in message
news:9lrj0q$bla$1@news.codecharge.com...
> Thanks Frank.
>
> This is what I have done but I don't know why I get the error null values
> not allowed from my database server (I'm using Oracle 8i). I checked the
> generated code and I found out that the fields which are defined as label
in
> CC is not included in the insert module. I just realized that I defined
> these fields as key fields and that's the reason why CC did not include
them
> in the insert sql statement. But when I unchecked the primary key tag
> checkbox for these fields, my form behaves errantly (it does not display
the
> record form for the record selected from a grid form -- it always displays
> the first record in the grid). Hope you can shed more light as to what I
am
> doing wrong. Thanks again.
>
> - Dante
>
>
>
> "Frank Rocco" <farocco@hotmail.com> wrote in message
>news:9lra06$rl6$1@news.codecharge.com...
> > Hi Dante,
> >
> > I got around this by changing the database fields to hidden and
assigning
> > the values to labels on the form so the user could see them, but would
not
> > be able to change them.
> >
> > HTH
> >
> > Frank
> >
> >
>
>
|
|
|
|
|
