PICK AND CHANGE SOME DATA

A

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
 
S

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)
 
A

ashraf_al_ani via AccessMonster.com

Sylvain said:
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
 
L

LUKE

ashraf_al_ani said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top