|
 |
asp_ado_rds thread: Editable computed field in Disconnected ADO Recordset
Message #1 by "Law Chin Choon" <chin_choon@h...> on Mon, 13 Aug 2001 02:46:00
|
|
Hi,
I am using Disconnected ADO Recordset 2.6. When I retrieve a set of
records which some columns are computed fields, I can't edit the column or
set a new value to the column....
Can anyone tell me how to solve the problem?
Thanks in advance...
Chin Choon
Message #2 by "Mohammed Abdul Azeem" <abdulazeem_it@h...> on Tue, 14 Aug 2001 05:28:31 +0000
|
|
Hi,
i am sending the code just u try it hope it should work.I worked with this
code.
set rs=Server.CreateObject("ADODB.Recordset")
rs.CursorLocation=adUseClient
rs.LockType=adOpenStatic
rs.Open "select * from emp10 where empno='1003'",con
Response.Write rs(0)&"<br>"
rs(0)="1001"
rs(1)="Azeem"
rs(2)="SE"
rs(3)="1000"
rs.Update
Azeem.
>From: "Law Chin Choon" <chin_choon@h...>
>Reply-To: "ASP_ADO_RDS" <asp_ado_rds@p...>
>To: "ASP_ADO_RDS" <asp_ado_rds@p...>
>Subject: [asp_ado_rds] Editable computed field in Disconnected ADO
>Recordset
>Date: Mon, 13 Aug 2001 06:38:26 +0100
>
>Hi,
>
>I am using Disconnected ADO Recordset 2.6. When I retrieve a set of
>records which some columns are computed fields, I can't edit the column or
>set a new value to the column....
>
>Can anyone tell me how to solve the problem?
>
>Thanks in advance...
>
>Chin Choon
>
Message #3 by "Law Chin Choon" <chin_choon@h...> on Wed, 15 Aug 2001 09:20:12 +0800
|
|
Hi,
Thanks for your response..
The problem is my sql statement is somekind as below:
select emp_id, emp_name, emp_age, (amp_age * 5) mycomputedfield from
employee;
when I try to edit r("mycomputedfield")...it will prompt me error cannot
edit uneditable field..
>From: "Mohammed Abdul Azeem" <abdulazeem_it@h...>
>Reply-To: "ASP_ADO_RDS" <asp_ado_rds@p...>
>To: "ASP_ADO_RDS" <asp_ado_rds@p...>
>Subject: [asp_ado_rds] Re: Editable computed field in Disconnected ADO
>Recordset
>Date: Tue, 14 Aug 2001 05:28:31 +0000
>
>Hi,
>
>i am sending the code just u try it hope it should work.I worked with this
>code.
>
>
>set rs=Server.CreateObject("ADODB.Recordset")
> rs.CursorLocation=adUseClient
> rs.LockType=adOpenStatic
> rs.Open "select * from emp10 where empno='1003'",con
> Response.Write rs(0)&"<br>"
>
> rs(0)="1001"
> rs(1)="Azeem"
> rs(2)="SE"
> rs(3)="1000"
> rs.Update
>
>
>Azeem.
>
>
>
>
>
Message #4 by "Wally Burfine" <oopconsultant@h...> on Wed, 15 Aug 2001 12:51:18 +0000
|
|
Hi,
You can't change computed fields in any recordset.
Wally
>From: "Law Chin Choon" <chin_choon@h...>
>Reply-To: "ASP_ADO_RDS" <asp_ado_rds@p...>
>To: "ASP_ADO_RDS" <asp_ado_rds@p...>
>Subject: [asp_ado_rds] Editable computed field in Disconnected ADO
>Recordset
>Date: Mon, 13 Aug 2001 06:38:26 +0100
>
>Hi,
>
>I am using Disconnected ADO Recordset 2.6. When I retrieve a set of
>records which some columns are computed fields, I can't edit the column or
>set a new value to the column....
>
>Can anyone tell me how to solve the problem?
>
>Thanks in advance...
>
>Chin Choon
|
|
|
View Cart
