PICK AND CHANGE SOME DATA

[ashraf_al_ani]

Dear All
i have a table contains data
I maid stored procedure in sql server 2000 has 2 parameter(@dept) and
(between @combo26 and combo26_) [the form is based on that stored procedure)

I get the wanted data but the problem i couldnt change any record

so how can i choose my data and make the changes i want??


best regards

 

[Sylvain Lafontaine]

Many possible reasons, the first one beeing the absence of a primary key but
they are other as well.

What version of ADP and of SQL-Server are you using and what is exactly this
query? If possible and necessary, also state the design of the tables.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)

 

[ashraf_al_ani via AccessMonster.com]

Many possible reasons, the first one beeing the absence of a primary key but
they are other as well.

What version of ADP and of SQL-Server are you using and what is exactly this
query? If possible and necessary, also state the design of the tables.

Dear All
i have a table contains data

[quoted text clipped - 7 lines]

best regards

Dear Sylvain
The Verson sql server 2000 and MS Access 2003

the result from the stored procdure is not updatable
so how can i pick data by parametes and change the selected data ??

best regards

 

[LUKE]

Dear All
i have a table contains data
I maid stored procedure in sql server 2000 has 2 parameter(@dept) and
(between @combo26 and combo26_) [the form is based on that stored
procedure)

I get the wanted data but the problem i couldnt change any record

so how can i choose my data and make the changes i want??


best regards