Updatable Stored Procedure?

Jim Covington

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Updatable Stored Procedure?

I have a dbEdit tied to a result set of a MSSQL 7.0 stored Procedure.
Apparently this result set is read only. How can I make this result set
updatable?

Richard Proudfoo

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Updatable Stored Procedure?

Jim,

Read the text of the dbEdit component into a parametised update query and
then execute the query or you can send the text to a stored procedure and
execute the update there.

Regards,
Richard

Quote

Jim Covington wrote in message <8qbamb$q6...@bornews.borland.com>...
>I have a dbEdit tied to a result set of a MSSQL 7.0 stored Procedure.
>Apparently this result set is read only. How can I make this result set
>updatable?

Tomislav Kard

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Updatable Stored Procedure?

Hi Jim!

On Wed, 20 Sep 2000 16:46:07 -0500, "Jim Covington"

Quote

<jwcov...@telapex.com> wrote:
>I have a dbEdit tied to a result set of a MSSQL 7.0 stored Procedure.
>Apparently this result set is read only. How can I make this result set
>updatable?

Use cached updates and make your own insert, update & delete SQL
statements based on fields from resulting dataset.

tomi.

Other Threads

1. Stored Procedures: not updatable

2. Updatable stored procedure with Delphi 4 ans MS Access ???

3. Stored Procedure - Passing Argument in to a Stored Procedure

4. Calling a stored procedure in another stored procedure in SQL Server 7.0

5. Stored Procedures.......Help Needed For A Stored Procedure {*word*269}

6. Stored Procedure: Valuelist as Stored Procedure Parameter

7. Using dbExpress Stored Procedure Component and Oracle 9i Stored Procedure

8. Oracle Stored Procedures - Procedures in Packages

9. storing and loading long strings with a stored procedure cuts after 255 chars

10. Stored Functions and Stored Procedures